Dataset statistics
| Number of variables | 53 |
|---|---|
| Number of observations | 180519 |
| Missing cells | 336209 |
| Missing cells (%) | 3.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 73.0 MiB |
| Average record size in memory | 424.0 B |
Variable types
| Categorical | 17 |
|---|---|
| Numeric | 24 |
| Text | 9 |
| DateTime | 2 |
| Unsupported | 1 |
Customer Email has constant value "" | Constant |
Customer Password has constant value "" | Constant |
Product Status has constant value "" | Constant |
Days for shipping (real) is highly overall correlated with Days for shipment (scheduled) and 3 other fields | High correlation |
Benefit per order is highly overall correlated with Order Item Profit Ratio and 1 other fields | High correlation |
Sales per customer is highly overall correlated with Order Item Product Price and 3 other fields | High correlation |
Category Id is highly overall correlated with Department Id and 5 other fields | High correlation |
Customer Id is highly overall correlated with Order Customer Id and 1 other fields | High correlation |
Customer Zipcode is highly overall correlated with Latitude and 3 other fields | High correlation |
Department Id is highly overall correlated with Category Id and 5 other fields | High correlation |
Latitude is highly overall correlated with Customer Zipcode and 3 other fields | High correlation |
Longitude is highly overall correlated with Customer Zipcode and 3 other fields | High correlation |
Order Customer Id is highly overall correlated with Customer Id and 1 other fields | High correlation |
Order Id is highly overall correlated with Order Item Id and 2 other fields | High correlation |
Order Item Cardprod Id is highly overall correlated with Category Id and 5 other fields | High correlation |
Order Item Discount is highly overall correlated with Order Item Discount Rate and 1 other fields | High correlation |
Order Item Discount Rate is highly overall correlated with Order Item Discount | High correlation |
Order Item Id is highly overall correlated with Order Id and 2 other fields | High correlation |
Order Item Product Price is highly overall correlated with Sales per customer and 4 other fields | High correlation |
Order Item Profit Ratio is highly overall correlated with Benefit per order and 1 other fields | High correlation |
Sales is highly overall correlated with Sales per customer and 5 other fields | High correlation |
Order Item Total is highly overall correlated with Sales per customer and 3 other fields | High correlation |
Order Profit Per Order is highly overall correlated with Benefit per order and 1 other fields | High correlation |
Order Zipcode is highly overall correlated with Market and 1 other fields | High correlation |
Product Card Id is highly overall correlated with Category Id and 5 other fields | High correlation |
Product Category Id is highly overall correlated with Category Id and 5 other fields | High correlation |
Product Price is highly overall correlated with Sales per customer and 4 other fields | High correlation |
Type is highly overall correlated with Order Status | High correlation |
Days for shipment (scheduled) is highly overall correlated with Days for shipping (real) and 1 other fields | High correlation |
Delivery Status is highly overall correlated with Days for shipping (real) and 2 other fields | High correlation |
Late_delivery_risk is highly overall correlated with Days for shipping (real) and 1 other fields | High correlation |
Category Name is highly overall correlated with Category Id and 10 other fields | High correlation |
Customer Country is highly overall correlated with Customer Zipcode and 3 other fields | High correlation |
Customer State is highly overall correlated with Customer Zipcode and 3 other fields | High correlation |
Department Name is highly overall correlated with Category Id and 5 other fields | High correlation |
Market is highly overall correlated with Order Id and 3 other fields | High correlation |
Order Region is highly overall correlated with Order Id and 3 other fields | High correlation |
Order Status is highly overall correlated with Type and 1 other fields | High correlation |
Shipping Mode is highly overall correlated with Days for shipping (real) and 1 other fields | High correlation |
Order Zipcode has 155679 (86.2%) missing values | Missing |
Product Description has 180519 (100.0%) missing values | Missing |
Order Item Id is uniformly distributed | Uniform |
Order Item Id has unique values | Unique |
Product Description is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Days for shipping (real) has 5080 (2.8%) zeros | Zeros |
Order Item Discount has 10028 (5.6%) zeros | Zeros |
Order Item Discount Rate has 10028 (5.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-07-08 12:28:53.186626 |
|---|---|
| Analysis finished | 2023-07-08 12:34:19.816759 |
| Duration | 5 minutes and 26.63 seconds |
| Software version | ydata-profiling vv4.3.1 |
| Download configuration | config.json |
Type
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| DEBIT | |
|---|---|
| TRANSFER | |
| PAYMENT | |
| CASH |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.1826068 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1116078 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DEBIT |
|---|---|
| 2nd row | TRANSFER |
| 3rd row | CASH |
| 4th row | DEBIT |
| 5th row | PAYMENT |
Common Values
| Value | Count | Frequency (%) |
| DEBIT | 69295 | |
| TRANSFER | 49883 | |
| PAYMENT | 41725 | |
| CASH | 19616 | 10.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| debit | 69295 | |
| transfer | 49883 | |
| payment | 41725 | |
| cash | 19616 | 10.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 160903 | |
| T | 160903 | |
| A | 111224 | |
| R | 99766 | |
| N | 91608 | |
| S | 69499 | |
| D | 69295 | |
| B | 69295 | |
| I | 69295 | |
| F | 49883 | 4.5% |
| Other values (5) | 164407 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1116078 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 160903 | |
| T | 160903 | |
| A | 111224 | |
| R | 99766 | |
| N | 91608 | |
| S | 69499 | |
| D | 69295 | |
| B | 69295 | |
| I | 69295 | |
| F | 49883 | 4.5% |
| Other values (5) | 164407 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1116078 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 160903 | |
| T | 160903 | |
| A | 111224 | |
| R | 99766 | |
| N | 91608 | |
| S | 69499 | |
| D | 69295 | |
| B | 69295 | |
| I | 69295 | |
| F | 49883 | 4.5% |
| Other values (5) | 164407 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1116078 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 160903 | |
| T | 160903 | |
| A | 111224 | |
| R | 99766 | |
| N | 91608 | |
| S | 69499 | |
| D | 69295 | |
| B | 69295 | |
| I | 69295 | |
| F | 49883 | 4.5% |
| Other values (5) | 164407 |
Days for shipping (real)
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.497654 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 5080 |
| Zeros (%) | 2.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.6237218 |
|---|---|
| Coefficient of variation (CV) | 0.46423169 |
| Kurtosis | -1.0079136 |
| Mean | 3.497654 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.084771273 |
| Sum | 631393 |
| Variance | 2.6364726 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 2 | 56618 | |
| 3 | 28765 | |
| 6 | 28723 | |
| 4 | 28513 | |
| 5 | 28163 | |
| 0 | 5080 | 2.8% |
| 1 | 4657 | 2.6% |
| Value | Count | Frequency (%) |
| 0 | 5080 | 2.8% |
| 1 | 4657 | 2.6% |
| 2 | 56618 | |
| 3 | 28765 | |
| 4 | 28513 | |
| 5 | 28163 | |
| 6 | 28723 |
| Value | Count | Frequency (%) |
| 6 | 28723 | |
| 5 | 28163 | |
| 4 | 28513 | |
| 3 | 28765 | |
| 2 | 56618 | |
| 1 | 4657 | 2.6% |
| 0 | 5080 | 2.8% |
Days for shipment (scheduled)
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 4 | |
|---|---|
| 2 | |
| 1 | |
| 0 | 9737 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 180519 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 4 |
| 3rd row | 4 |
| 4th row | 4 |
| 5th row | 4 |
Common Values
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 180519 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 180519 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 180519 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 107752 | |
| 2 | 35216 | 19.5% |
| 1 | 27814 | 15.4% |
| 0 | 9737 | 5.4% |
Benefit per order
Real number (ℝ)
HIGH CORRELATION
| Distinct | 21998 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.974989 |
| Minimum | -4274.98 |
|---|---|
| Maximum | 911.79999 |
| Zeros | 1177 |
| Zeros (%) | 0.7% |
| Negative | 33784 |
| Negative (%) | 18.7% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -4274.98 |
|---|---|
| 5-th percentile | -139.251 |
| Q1 | 7 |
| median | 31.52 |
| Q3 | 64.800003 |
| 95-th percentile | 132.28999 |
| Maximum | 911.79999 |
| Range | 5186.78 |
| Interquartile range (IQR) | 57.800003 |
Descriptive statistics
| Standard deviation | 104.43353 |
|---|---|
| Coefficient of variation (CV) | 4.7523813 |
| Kurtosis | 71.377259 |
| Mean | 21.974989 |
| Median Absolute Deviation (MAD) | 27.88 |
| Skewness | -4.7418341 |
| Sum | 3966903 |
| Variance | 10906.361 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1177 | 0.7% |
| 143.9900055 | 199 | 0.1% |
| 72 | 194 | 0.1% |
| 46.79999924 | 188 | 0.1% |
| 24 | 181 | 0.1% |
| 18 | 175 | 0.1% |
| 63.70000076 | 172 | 0.1% |
| 62.40000153 | 168 | 0.1% |
| 12 | 166 | 0.1% |
| 14.39999962 | 166 | 0.1% |
| Other values (21988) | 177733 |
| Value | Count | Frequency (%) |
| -4274.97998 | 1 | |
| -3442.5 | 1 | |
| -3366 | 1 | |
| -3000 | 1 | |
| -2592 | 1 | |
| -2550 | 1 | |
| -2351.25 | 1 | |
| -2328 | 1 | |
| -2280 | 1 | |
| -2255.25 | 1 |
| Value | Count | Frequency (%) |
| 911.7999878 | 1 | |
| 864 | 1 | |
| 721.5999756 | 1 | |
| 720.2999878 | 1 | |
| 720 | 2 | |
| 712.9500122 | 1 | |
| 708.75 | 1 | |
| 705.5999756 | 2 | |
| 705 | 1 | |
| 698.4000244 | 2 |
Sales per customer
Real number (ℝ)
HIGH CORRELATION
| Distinct | 2927 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 183.10761 |
| Minimum | 7.4899998 |
|---|---|
| Maximum | 1939.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 7.4899998 |
|---|---|
| 5-th percentile | 41.5 |
| Q1 | 104.38 |
| median | 163.99001 |
| Q3 | 247.39999 |
| 95-th percentile | 383.98001 |
| Maximum | 1939.99 |
| Range | 1932.5 |
| Interquartile range (IQR) | 143.02 |
Descriptive statistics
| Standard deviation | 120.04367 |
|---|---|
| Coefficient of variation (CV) | 0.65559084 |
| Kurtosis | 23.920362 |
| Mean | 183.10761 |
| Median Absolute Deviation (MAD) | 67.000008 |
| Skewness | 2.8884461 |
| Sum | 33054402 |
| Variance | 14410.483 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 122.8399963 | 1264 | 0.7% |
| 109.1900024 | 1247 | 0.7% |
| 124.7900009 | 1243 | 0.7% |
| 129.9900055 | 1243 | 0.7% |
| 116.9899979 | 1243 | 0.7% |
| 123.4899979 | 1243 | 0.7% |
| 120.8899994 | 1243 | 0.7% |
| 127.3899994 | 1243 | 0.7% |
| 97.48999786 | 1243 | 0.7% |
| 118.2900009 | 1243 | 0.7% |
| Other values (2917) | 168064 |
| Value | Count | Frequency (%) |
| 7.489999771 | 3 | < 0.1% |
| 7.989999771 | 3 | < 0.1% |
| 8.18999958 | 3 | < 0.1% |
| 8.289999962 | 3 | < 0.1% |
| 8.390000343 | 3 | < 0.1% |
| 8.470000267 | 15 | |
| 8.489999771 | 3 | < 0.1% |
| 8.659999847 | 29 | |
| 8.68999958 | 3 | < 0.1% |
| 8.789999962 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 1939.98999 | 1 | |
| 1919.98999 | 1 | |
| 1899.98999 | 1 | |
| 1889.98999 | 1 | |
| 1859.98999 | 1 | |
| 1819.98999 | 1 | |
| 1799.98999 | 1 | |
| 1759.98999 | 1 | |
| 1739.98999 | 1 | |
| 1699.98999 | 1 |
Delivery Status
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Late delivery | |
|---|---|
| Advance shipping | |
| Shipping on time | |
| Shipping canceled | 7754 |
Length
| Max length | 17 |
|---|---|
| Median length | 13 |
| Mean length | 14.39808 |
| Min length | 13 |
Characters and Unicode
| Total characters | 2599127 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Advance shipping |
|---|---|
| 2nd row | Late delivery |
| 3rd row | Shipping on time |
| 4th row | Advance shipping |
| 5th row | Advance shipping |
Common Values
| Value | Count | Frequency (%) |
| Late delivery | 98977 | |
| Advance shipping | 41592 | |
| Shipping on time | 32196 | 17.8% |
| Shipping canceled | 7754 | 4.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| late | 98977 | |
| delivery | 98977 | |
| shipping | 81542 | |
| advance | 41592 | |
| on | 32196 | 8.2% |
| time | 32196 | 8.2% |
| canceled | 7754 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 386227 | |
| i | 294257 | |
| 212715 | 8.2% | |
| n | 163084 | 6.3% |
| p | 163084 | 6.3% |
| d | 148323 | 5.7% |
| a | 148323 | 5.7% |
| v | 140569 | 5.4% |
| t | 131173 | 5.0% |
| l | 106731 | 4.1% |
| Other values (11) | 704641 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2205893 | |
| Space Separator | 212715 | 8.2% |
| Uppercase Letter | 180519 | 6.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 386227 | |
| i | 294257 | |
| n | 163084 | 7.4% |
| p | 163084 | 7.4% |
| d | 148323 | 6.7% |
| a | 148323 | 6.7% |
| v | 140569 | 6.4% |
| t | 131173 | 5.9% |
| l | 106731 | 4.8% |
| y | 98977 | 4.5% |
| Other values (7) | 425145 |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 98977 | |
| A | 41592 | |
| S | 39950 |
Space Separator
| Value | Count | Frequency (%) |
| 212715 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2386412 | |
| Common | 212715 | 8.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 386227 | |
| i | 294257 | |
| n | 163084 | 6.8% |
| p | 163084 | 6.8% |
| d | 148323 | 6.2% |
| a | 148323 | 6.2% |
| v | 140569 | 5.9% |
| t | 131173 | 5.5% |
| l | 106731 | 4.5% |
| L | 98977 | 4.1% |
| Other values (10) | 605664 |
Common
| Value | Count | Frequency (%) |
| 212715 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2599127 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 386227 | |
| i | 294257 | |
| 212715 | 8.2% | |
| n | 163084 | 6.3% |
| p | 163084 | 6.3% |
| d | 148323 | 5.7% |
| a | 148323 | 5.7% |
| v | 140569 | 5.4% |
| t | 131173 | 5.0% |
| l | 106731 | 4.1% |
| Other values (11) | 704641 |
Late_delivery_risk
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 180519 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 180519 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 180519 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 180519 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 98977 | |
| 0 | 81542 |
Category Id
Real number (ℝ)
HIGH CORRELATION
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.851451 |
| Minimum | 2 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 18 |
| median | 29 |
| Q3 | 45 |
| 95-th percentile | 48 |
| Maximum | 76 |
| Range | 74 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 15.640064 |
|---|---|
| Coefficient of variation (CV) | 0.49103145 |
| Kurtosis | -0.60326101 |
| Mean | 31.851451 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 0.3616248 |
| Sum | 5749792 |
| Variance | 244.6116 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 17 | 24551 | |
| 18 | 22246 | |
| 24 | 21035 | |
| 46 | 19298 | |
| 45 | 17325 | |
| 48 | 15540 | |
| 43 | 13729 | |
| 9 | 12487 | |
| 29 | 10984 | |
| 37 | 2029 | 1.1% |
| Other values (41) | 21295 |
| Value | Count | Frequency (%) |
| 2 | 138 | 0.1% |
| 3 | 632 | 0.4% |
| 4 | 67 | < 0.1% |
| 5 | 343 | 0.2% |
| 6 | 328 | 0.2% |
| 7 | 614 | 0.3% |
| 9 | 12487 | |
| 10 | 111 | 0.1% |
| 11 | 309 | 0.2% |
| 12 | 423 | 0.2% |
| Value | Count | Frequency (%) |
| 76 | 650 | |
| 75 | 838 | |
| 74 | 529 | |
| 73 | 357 | |
| 72 | 492 | |
| 71 | 434 | |
| 70 | 208 | 0.1% |
| 69 | 362 | |
| 68 | 484 | |
| 67 | 483 |
Category Name
Categorical
HIGH CORRELATION
| Distinct | 50 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Cleats | |
|---|---|
| Men's Footwear | |
| Women's Apparel | |
| Indoor/Outdoor Games | |
| Fishing | |
| Other values (45) |
Length
| Max length | 20 |
|---|---|
| Median length | 17 |
| Mean length | 12.707793 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2293998 |
|---|---|
| Distinct characters | 49 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Sporting Goods |
|---|---|
| 2nd row | Sporting Goods |
| 3rd row | Sporting Goods |
| 4th row | Sporting Goods |
| 5th row | Sporting Goods |
Common Values
| Value | Count | Frequency (%) |
| Cleats | 24551 | |
| Men's Footwear | 22246 | |
| Women's Apparel | 21035 | |
| Indoor/Outdoor Games | 19298 | |
| Fishing | 17325 | |
| Water Sports | 15540 | |
| Camping & Hiking | 13729 | |
| Cardio Equipment | 12487 | |
| Shop By Sport | 10984 | |
| Electronics | 3156 | 1.7% |
| Other values (40) | 20168 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| cleats | 24551 | 7.3% |
| men's | 22737 | 6.8% |
| apparel | 22677 | 6.8% |
| footwear | 22246 | 6.6% |
| women's | 21866 | 6.5% |
| games | 20136 | 6.0% |
| indoor/outdoor | 19298 | 5.7% |
| fishing | 17325 | 5.2% |
| 15613 | 4.7% | |
| water | 15540 | 4.6% |
| Other values (60) | 133774 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 213963 | 9.3% |
| e | 180726 | 7.9% |
| 156787 | 6.8% | |
| r | 150127 | 6.5% |
| s | 145604 | 6.3% |
| a | 140194 | 6.1% |
| n | 132705 | 5.8% |
| t | 130741 | 5.7% |
| i | 114517 | 5.0% |
| p | 110861 | 4.8% |
| Other values (39) | 817773 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1712275 | |
| Uppercase Letter | 342143 | 14.9% |
| Space Separator | 156787 | 6.8% |
| Other Punctuation | 81819 | 3.6% |
| Dash Punctuation | 974 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 213963 | |
| e | 180726 | |
| r | 150127 | |
| s | 145604 | |
| a | 140194 | |
| n | 132705 | |
| t | 130741 | |
| i | 114517 | 6.7% |
| p | 110861 | 6.5% |
| m | 69683 | 4.1% |
| Other values (14) | 323154 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 56058 | |
| S | 40270 | |
| F | 39880 | |
| W | 37406 | |
| G | 27667 | |
| A | 25257 | |
| M | 24017 | |
| I | 20272 | 5.9% |
| O | 19298 | 5.6% |
| E | 16074 | 4.7% |
| Other values (9) | 35944 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 46840 | |
| / | 19298 | |
| & | 15613 | 19.1% |
| ! | 68 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 156787 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 974 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2054418 | |
| Common | 239580 | 10.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 213963 | 10.4% |
| e | 180726 | 8.8% |
| r | 150127 | 7.3% |
| s | 145604 | 7.1% |
| a | 140194 | 6.8% |
| n | 132705 | 6.5% |
| t | 130741 | 6.4% |
| i | 114517 | 5.6% |
| p | 110861 | 5.4% |
| m | 69683 | 3.4% |
| Other values (33) | 665297 |
Common
| Value | Count | Frequency (%) |
| 156787 | ||
| ' | 46840 | 19.6% |
| / | 19298 | 8.1% |
| & | 15613 | 6.5% |
| - | 974 | 0.4% |
| ! | 68 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2293998 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 213963 | 9.3% |
| e | 180726 | 7.9% |
| 156787 | 6.8% | |
| r | 150127 | 6.5% |
| s | 145604 | 6.3% |
| a | 140194 | 6.1% |
| n | 132705 | 5.8% |
| t | 130741 | 5.7% |
| i | 114517 | 5.0% |
| p | 110861 | 4.8% |
| Other values (39) | 817773 |
Customer City
Text
| Distinct | 563 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 19 |
| Mean length | 7.7086235 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1391553 |
|---|---|
| Distinct characters | 52 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Caguas |
|---|---|
| 2nd row | Caguas |
| 3rd row | San Jose |
| 4th row | Los Angeles |
| 5th row | Caguas |
| Value | Count | Frequency (%) |
| caguas | 66770 | |
| san | 5129 | 2.4% |
| chicago | 3937 | 1.8% |
| los | 3417 | 1.6% |
| angeles | 3417 | 1.6% |
| brooklyn | 3412 | 1.6% |
| new | 3107 | 1.4% |
| york | 2165 | 1.0% |
| beach | 2084 | 1.0% |
| city | 1659 | 0.8% |
| Other values (585) | 121822 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 228937 | |
| s | 111699 | 8.0% |
| u | 89280 | 6.4% |
| g | 89233 | 6.4% |
| o | 85515 | 6.1% |
| C | 82588 | 5.9% |
| e | 81172 | 5.8% |
| n | 76231 | 5.5% |
| l | 60937 | 4.4% |
| i | 60636 | 4.4% |
| Other values (42) | 425325 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1138231 | |
| Uppercase Letter | 216922 | 15.6% |
| Space Separator | 36400 | 2.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 228937 | |
| s | 111699 | |
| u | 89280 | 7.8% |
| g | 89233 | 7.8% |
| o | 85515 | 7.5% |
| e | 81172 | 7.1% |
| n | 76231 | 6.7% |
| l | 60937 | 5.4% |
| i | 60636 | 5.3% |
| r | 57370 | 5.0% |
| Other values (16) | 197221 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 82588 | |
| S | 14019 | 6.5% |
| B | 13944 | 6.4% |
| L | 13048 | 6.0% |
| A | 10848 | 5.0% |
| P | 10565 | 4.9% |
| M | 9378 | 4.3% |
| H | 8518 | 3.9% |
| D | 5758 | 2.7% |
| N | 5664 | 2.6% |
| Other values (15) | 42592 |
Space Separator
| Value | Count | Frequency (%) |
| 36400 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1355153 | |
| Common | 36400 | 2.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 228937 | |
| s | 111699 | 8.2% |
| u | 89280 | 6.6% |
| g | 89233 | 6.6% |
| o | 85515 | 6.3% |
| C | 82588 | 6.1% |
| e | 81172 | 6.0% |
| n | 76231 | 5.6% |
| l | 60937 | 4.5% |
| i | 60636 | 4.5% |
| Other values (41) | 388925 |
Common
| Value | Count | Frequency (%) |
| 36400 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1391553 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 228937 | |
| s | 111699 | 8.0% |
| u | 89280 | 6.4% |
| g | 89233 | 6.4% |
| o | 85515 | 6.1% |
| C | 82588 | 5.9% |
| e | 81172 | 5.8% |
| n | 76231 | 5.5% |
| l | 60937 | 4.4% |
| i | 60636 | 4.4% |
| Other values (42) | 425325 |
Customer Country
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| EE. UU. | |
|---|---|
| Puerto Rico |
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 8.53719 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1541125 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Puerto Rico |
|---|---|
| 2nd row | Puerto Rico |
| 3rd row | EE. UU. |
| 4th row | EE. UU. |
| 5th row | Puerto Rico |
Common Values
| Value | Count | Frequency (%) |
| EE. UU. | 111146 | |
| Puerto Rico | 69373 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ee | 111146 | |
| uu | 111146 | |
| puerto | 69373 | |
| rico | 69373 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 222292 | |
| . | 222292 | |
| U | 222292 | |
| 180519 | ||
| o | 138746 | |
| P | 69373 | 4.5% |
| u | 69373 | 4.5% |
| e | 69373 | 4.5% |
| r | 69373 | 4.5% |
| t | 69373 | 4.5% |
| Other values (3) | 208119 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 583330 | |
| Lowercase Letter | 554984 | |
| Other Punctuation | 222292 | 14.4% |
| Space Separator | 180519 | 11.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 138746 | |
| u | 69373 | |
| e | 69373 | |
| r | 69373 | |
| t | 69373 | |
| i | 69373 | |
| c | 69373 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 222292 | |
| U | 222292 | |
| P | 69373 | 11.9% |
| R | 69373 | 11.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 222292 |
Space Separator
| Value | Count | Frequency (%) |
| 180519 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1138314 | |
| Common | 402811 | 26.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 222292 | |
| U | 222292 | |
| o | 138746 | |
| P | 69373 | 6.1% |
| u | 69373 | 6.1% |
| e | 69373 | 6.1% |
| r | 69373 | 6.1% |
| t | 69373 | 6.1% |
| R | 69373 | 6.1% |
| i | 69373 | 6.1% |
Common
| Value | Count | Frequency (%) |
| . | 222292 | |
| 180519 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1541125 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 222292 | |
| . | 222292 | |
| U | 222292 | |
| 180519 | ||
| o | 138746 | |
| P | 69373 | 4.5% |
| u | 69373 | 4.5% |
| e | 69373 | 4.5% |
| r | 69373 | 4.5% |
| t | 69373 | 4.5% |
| Other values (3) | 208119 |
Customer Email
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| XXXXXXXXX |
|---|
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1624671 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | XXXXXXXXX |
|---|---|
| 2nd row | XXXXXXXXX |
| 3rd row | XXXXXXXXX |
| 4th row | XXXXXXXXX |
| 5th row | XXXXXXXXX |
Common Values
| Value | Count | Frequency (%) |
| XXXXXXXXX | 180519 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| xxxxxxxxx | 180519 |
Most occurring characters
| Value | Count | Frequency (%) |
| X | 1624671 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1624671 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| X | 1624671 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1624671 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| X | 1624671 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1624671 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| X | 1624671 |
Customer Fname
Text
| Distinct | 782 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 5.2746581 |
| Min length | 2 |
Characters and Unicode
| Total characters | 952176 |
|---|---|
| Distinct characters | 52 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 48 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Cally |
|---|---|
| 2nd row | Irene |
| 3rd row | Gillian |
| 4th row | Tana |
| 5th row | Orli |
| Value | Count | Frequency (%) |
| mary | 65150 | |
| james | 1835 | 1.0% |
| robert | 1759 | 1.0% |
| michael | 1680 | 0.9% |
| david | 1625 | 0.9% |
| john | 1446 | 0.8% |
| william | 1365 | 0.8% |
| joseph | 1117 | 0.6% |
| jennifer | 1033 | 0.6% |
| richard | 1032 | 0.6% |
| Other values (771) | 102477 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 153270 | |
| r | 117429 | |
| y | 88689 | 9.3% |
| M | 74129 | 7.8% |
| e | 72908 | 7.7% |
| n | 54931 | 5.8% |
| i | 46547 | 4.9% |
| l | 35613 | 3.7% |
| h | 34074 | 3.6% |
| t | 29586 | 3.1% |
| Other values (42) | 245000 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 771639 | |
| Uppercase Letter | 180537 | 19.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 153270 | |
| r | 117429 | |
| y | 88689 | |
| e | 72908 | |
| n | 54931 | 7.1% |
| i | 46547 | 6.0% |
| l | 35613 | 4.6% |
| h | 34074 | 4.4% |
| t | 29586 | 3.8% |
| o | 28643 | 3.7% |
| Other values (16) | 109949 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 74129 | |
| J | 17904 | 9.9% |
| A | 9925 | 5.5% |
| D | 9002 | 5.0% |
| R | 8843 | 4.9% |
| S | 8325 | 4.6% |
| C | 7590 | 4.2% |
| K | 6357 | 3.5% |
| B | 6086 | 3.4% |
| E | 4836 | 2.7% |
| Other values (16) | 27540 | 15.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 952176 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 153270 | |
| r | 117429 | |
| y | 88689 | 9.3% |
| M | 74129 | 7.8% |
| e | 72908 | 7.7% |
| n | 54931 | 5.8% |
| i | 46547 | 4.9% |
| l | 35613 | 3.7% |
| h | 34074 | 3.6% |
| t | 29586 | 3.1% |
| Other values (42) | 245000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 952176 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 153270 | |
| r | 117429 | |
| y | 88689 | 9.3% |
| M | 74129 | 7.8% |
| e | 72908 | 7.7% |
| n | 54931 | 5.8% |
| i | 46547 | 4.9% |
| l | 35613 | 3.7% |
| h | 34074 | 3.6% |
| t | 29586 | 3.1% |
| Other values (42) | 245000 |
Customer Id
Real number (ℝ)
HIGH CORRELATION
| Distinct | 20652 |
|---|---|
| Distinct (%) | 11.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6691.3795 |
| Minimum | 1 |
|---|---|
| Maximum | 20757 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 649 |
| Q1 | 3258.5 |
| median | 6457 |
| Q3 | 9779 |
| 95-th percentile | 12383 |
| Maximum | 20757 |
| Range | 20756 |
| Interquartile range (IQR) | 6520.5 |
Descriptive statistics
| Standard deviation | 4162.9181 |
|---|---|
| Coefficient of variation (CV) | 0.62213152 |
| Kurtosis | 0.014898822 |
| Mean | 6691.3795 |
| Median Absolute Deviation (MAD) | 3263 |
| Skewness | 0.48876825 |
| Sum | 1.2079211 × 109 |
| Variance | 17329887 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5654 | 47 | < 0.1% |
| 10591 | 45 | < 0.1% |
| 5004 | 45 | < 0.1% |
| 5715 | 44 | < 0.1% |
| 3708 | 44 | < 0.1% |
| 9371 | 44 | < 0.1% |
| 1443 | 43 | < 0.1% |
| 791 | 43 | < 0.1% |
| 12284 | 43 | < 0.1% |
| 2641 | 43 | < 0.1% |
| Other values (20642) | 180078 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2 | 10 | |
| 3 | 18 | |
| 4 | 14 | |
| 5 | 7 | < 0.1% |
| 6 | 15 | |
| 7 | 22 | |
| 8 | 19 | |
| 9 | 14 | |
| 10 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 20757 | 1 | |
| 20756 | 1 | |
| 20755 | 1 | |
| 20754 | 1 | |
| 20753 | 1 | |
| 20752 | 1 | |
| 20751 | 1 | |
| 20750 | 1 | |
| 20749 | 1 | |
| 20748 | 1 |
Customer Lname
Text
| Distinct | 1109 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 8 |
| Missing (%) | < 0.1% |
| Memory size | 1.4 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 11 |
| Mean length | 5.7124109 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1031153 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 29 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Holloway |
|---|---|
| 2nd row | Luna |
| 3rd row | Maldonado |
| 4th row | Tate |
| 5th row | Hendricks |
| Value | Count | Frequency (%) |
| smith | 64104 | |
| johnson | 989 | 0.5% |
| brown | 909 | 0.5% |
| williams | 869 | 0.5% |
| jones | 859 | 0.5% |
| garcia | 724 | 0.4% |
| wilson | 675 | 0.4% |
| taylor | 661 | 0.4% |
| davis | 640 | 0.4% |
| moore | 599 | 0.3% |
| Other values (1099) | 109482 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 98958 | 9.6% |
| t | 89337 | 8.7% |
| h | 80056 | 7.8% |
| m | 76994 | 7.5% |
| S | 72853 | 7.1% |
| e | 71442 | 6.9% |
| r | 61613 | 6.0% |
| a | 60479 | 5.9% |
| n | 60324 | 5.9% |
| o | 54728 | 5.3% |
| Other values (41) | 304369 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 850642 | |
| Uppercase Letter | 180511 | 17.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 98958 | |
| t | 89337 | |
| h | 80056 | |
| m | 76994 | |
| e | 71442 | |
| r | 61613 | 7.2% |
| a | 60479 | 7.1% |
| n | 60324 | 7.1% |
| o | 54728 | 6.4% |
| l | 41923 | 4.9% |
| Other values (16) | 154788 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 72853 | |
| M | 12703 | 7.0% |
| H | 10338 | 5.7% |
| B | 9912 | 5.5% |
| C | 9589 | 5.3% |
| W | 8613 | 4.8% |
| R | 7704 | 4.3% |
| G | 6598 | 3.7% |
| P | 6470 | 3.6% |
| L | 4992 | 2.8% |
| Other values (15) | 30739 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1031153 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 98958 | 9.6% |
| t | 89337 | 8.7% |
| h | 80056 | 7.8% |
| m | 76994 | 7.5% |
| S | 72853 | 7.1% |
| e | 71442 | 6.9% |
| r | 61613 | 6.0% |
| a | 60479 | 5.9% |
| n | 60324 | 5.9% |
| o | 54728 | 5.3% |
| Other values (41) | 304369 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1031153 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 98958 | 9.6% |
| t | 89337 | 8.7% |
| h | 80056 | 7.8% |
| m | 76994 | 7.5% |
| S | 72853 | 7.1% |
| e | 71442 | 6.9% |
| r | 61613 | 6.0% |
| a | 60479 | 5.9% |
| n | 60324 | 5.9% |
| o | 54728 | 5.3% |
| Other values (41) | 304369 |
Customer Password
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| XXXXXXXXX |
|---|
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1624671 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | XXXXXXXXX |
|---|---|
| 2nd row | XXXXXXXXX |
| 3rd row | XXXXXXXXX |
| 4th row | XXXXXXXXX |
| 5th row | XXXXXXXXX |
Common Values
| Value | Count | Frequency (%) |
| XXXXXXXXX | 180519 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| xxxxxxxxx | 180519 |
Most occurring characters
| Value | Count | Frequency (%) |
| X | 1624671 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1624671 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| X | 1624671 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1624671 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| X | 1624671 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1624671 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| X | 1624671 |
Customer Segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.839064 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1595619 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Consumer |
| 4th row | Home Office |
| 5th row | Corporate |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 93504 | |
| Corporate | 54789 | |
| Home Office | 32226 | 17.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 93504 | |
| corporate | 54789 | |
| home | 32226 | 15.1% |
| office | 32226 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 235308 | |
| e | 212745 | |
| r | 203082 | |
| C | 148293 | |
| m | 125730 | |
| n | 93504 | 5.9% |
| s | 93504 | 5.9% |
| u | 93504 | 5.9% |
| f | 64452 | 4.0% |
| t | 54789 | 3.4% |
| Other values (7) | 270708 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1350648 | |
| Uppercase Letter | 212745 | 13.3% |
| Space Separator | 32226 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 235308 | |
| e | 212745 | |
| r | 203082 | |
| m | 125730 | |
| n | 93504 | 6.9% |
| s | 93504 | 6.9% |
| u | 93504 | 6.9% |
| f | 64452 | 4.8% |
| t | 54789 | 4.1% |
| p | 54789 | 4.1% |
| Other values (3) | 119241 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 148293 | |
| H | 32226 | 15.1% |
| O | 32226 | 15.1% |
Space Separator
| Value | Count | Frequency (%) |
| 32226 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1563393 | |
| Common | 32226 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 235308 | |
| e | 212745 | |
| r | 203082 | |
| C | 148293 | |
| m | 125730 | |
| n | 93504 | 6.0% |
| s | 93504 | 6.0% |
| u | 93504 | 6.0% |
| f | 64452 | 4.1% |
| t | 54789 | 3.5% |
| Other values (6) | 238482 |
Common
| Value | Count | Frequency (%) |
| 32226 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1595619 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 235308 | |
| e | 212745 | |
| r | 203082 | |
| C | 148293 | |
| m | 125730 | |
| n | 93504 | 5.9% |
| s | 93504 | 5.9% |
| u | 93504 | 5.9% |
| f | 64452 | 4.0% |
| t | 54789 | 3.4% |
| Other values (7) | 270708 |
Customer State
Categorical
HIGH CORRELATION
| Distinct | 46 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| PR | |
|---|---|
| CA | |
| NY | |
| TX | |
| IL | |
| Other values (41) |
Length
| Max length | 5 |
|---|---|
| Median length | 2 |
| Mean length | 2.0000499 |
| Min length | 2 |
Characters and Unicode
| Total characters | 361047 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PR |
|---|---|
| 2nd row | PR |
| 3rd row | CA |
| 4th row | CA |
| 5th row | PR |
Common Values
| Value | Count | Frequency (%) |
| PR | 69373 | |
| CA | 29223 | |
| NY | 11327 | 6.3% |
| TX | 9103 | 5.0% |
| IL | 7631 | 4.2% |
| FL | 5456 | 3.0% |
| OH | 4095 | 2.3% |
| PA | 3824 | 2.1% |
| MI | 3804 | 2.1% |
| NJ | 3191 | 1.8% |
| Other values (36) | 33492 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| pr | 69373 | |
| ca | 29223 | |
| ny | 11327 | 6.3% |
| tx | 9103 | 5.0% |
| il | 7631 | 4.2% |
| fl | 5456 | 3.0% |
| oh | 4095 | 2.3% |
| pa | 3824 | 2.1% |
| mi | 3804 | 2.1% |
| nj | 3191 | 1.8% |
| Other values (36) | 33492 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 73197 | |
| R | 71448 | |
| A | 44166 | |
| C | 35467 | |
| N | 21949 | 6.1% |
| I | 14591 | 4.0% |
| L | 14070 | 3.9% |
| T | 12834 | 3.6% |
| Y | 11814 | 3.3% |
| M | 10888 | 3.0% |
| Other values (21) | 50623 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 361032 | |
| Decimal Number | 15 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 73197 | |
| R | 71448 | |
| A | 44166 | |
| C | 35467 | |
| N | 21949 | 6.1% |
| I | 14591 | 4.0% |
| L | 14070 | 3.9% |
| T | 12834 | 3.6% |
| Y | 11814 | 3.3% |
| M | 10888 | 3.0% |
| Other values (14) | 50608 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 4 | |
| 9 | 3 | |
| 7 | 3 | |
| 8 | 2 | |
| 1 | 1 | 6.7% |
| 3 | 1 | 6.7% |
| 2 | 1 | 6.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 361032 | |
| Common | 15 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 73197 | |
| R | 71448 | |
| A | 44166 | |
| C | 35467 | |
| N | 21949 | 6.1% |
| I | 14591 | 4.0% |
| L | 14070 | 3.9% |
| T | 12834 | 3.6% |
| Y | 11814 | 3.3% |
| M | 10888 | 3.0% |
| Other values (14) | 50608 |
Common
| Value | Count | Frequency (%) |
| 5 | 4 | |
| 9 | 3 | |
| 7 | 3 | |
| 8 | 2 | |
| 1 | 1 | 6.7% |
| 3 | 1 | 6.7% |
| 2 | 1 | 6.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 361047 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 73197 | |
| R | 71448 | |
| A | 44166 | |
| C | 35467 | |
| N | 21949 | 6.1% |
| I | 14591 | 4.0% |
| L | 14070 | 3.9% |
| T | 12834 | 3.6% |
| Y | 11814 | 3.3% |
| M | 10888 | 3.0% |
| Other values (21) | 50623 |
Customer Street
Text
| Distinct | 7458 |
|---|---|
| Distinct (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 33 |
|---|---|
| Median length | 28 |
| Mean length | 19.957113 |
| Min length | 8 |
Characters and Unicode
| Total characters | 3602638 |
|---|---|
| Distinct characters | 61 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 483 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 5365 Noble Nectar Island |
|---|---|
| 2nd row | 2679 Rustic Loop |
| 3rd row | 8510 Round Bear Gate |
| 4th row | 3200 Amber Bend |
| 5th row | 8671 Iron Anchor Corners |
| Value | Count | Frequency (%) |
| green | 4491 | 0.7% |
| round | 4181 | 0.7% |
| golden | 3710 | 0.6% |
| clear | 3684 | 0.6% |
| rustic | 3659 | 0.6% |
| thunder | 3616 | 0.6% |
| honey | 3604 | 0.6% |
| velvet | 3538 | 0.6% |
| heather | 3513 | 0.6% |
| misty | 3508 | 0.6% |
| Other values (3299) | 592865 |
Most occurring characters
| Value | Count | Frequency (%) |
| 452905 | 12.6% | |
| e | 266514 | 7.4% |
| a | 188658 | 5.2% |
| n | 172491 | 4.8% |
| r | 166038 | 4.6% |
| o | 162182 | 4.5% |
| l | 132873 | 3.7% |
| i | 132088 | 3.7% |
| t | 117744 | 3.3% |
| s | 101650 | 2.8% |
| Other values (51) | 1709495 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1995175 | |
| Decimal Number | 703140 | 19.5% |
| Space Separator | 452905 | 12.6% |
| Uppercase Letter | 449853 | 12.5% |
| Dash Punctuation | 1565 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 266514 | |
| a | 188658 | |
| n | 172491 | 8.6% |
| r | 166038 | 8.3% |
| o | 162182 | 8.1% |
| l | 132873 | 6.7% |
| i | 132088 | 6.6% |
| t | 117744 | 5.9% |
| s | 101650 | 5.1% |
| d | 90014 | 4.5% |
| Other values (15) | 464923 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 48068 | 10.7% |
| B | 36535 | 8.1% |
| H | 34142 | 7.6% |
| R | 31731 | 7.1% |
| P | 31630 | 7.0% |
| S | 29549 | 6.6% |
| L | 27209 | 6.0% |
| G | 26549 | 5.9% |
| M | 22218 | 4.9% |
| F | 20196 | 4.5% |
| Other values (14) | 142026 |
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 75478 | |
| 1 | 74531 | |
| 9 | 74093 | |
| 4 | 72421 | |
| 3 | 71753 | |
| 5 | 71310 | |
| 2 | 70868 | |
| 6 | 70687 | |
| 8 | 69639 | |
| 0 | 52360 |
Space Separator
| Value | Count | Frequency (%) |
| 452905 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1565 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2445028 | |
| Common | 1157610 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 266514 | 10.9% |
| a | 188658 | 7.7% |
| n | 172491 | 7.1% |
| r | 166038 | 6.8% |
| o | 162182 | 6.6% |
| l | 132873 | 5.4% |
| i | 132088 | 5.4% |
| t | 117744 | 4.8% |
| s | 101650 | 4.2% |
| d | 90014 | 3.7% |
| Other values (39) | 914776 |
Common
| Value | Count | Frequency (%) |
| 452905 | ||
| 7 | 75478 | 6.5% |
| 1 | 74531 | 6.4% |
| 9 | 74093 | 6.4% |
| 4 | 72421 | 6.3% |
| 3 | 71753 | 6.2% |
| 5 | 71310 | 6.2% |
| 2 | 70868 | 6.1% |
| 6 | 70687 | 6.1% |
| 8 | 69639 | 6.0% |
| Other values (2) | 53925 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3602638 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 452905 | 12.6% | |
| e | 266514 | 7.4% |
| a | 188658 | 5.2% |
| n | 172491 | 4.8% |
| r | 166038 | 4.6% |
| o | 162182 | 4.5% |
| l | 132873 | 3.7% |
| i | 132088 | 3.7% |
| t | 117744 | 3.3% |
| s | 101650 | 2.8% |
| Other values (51) | 1709495 |
Customer Zipcode
Real number (ℝ)
HIGH CORRELATION
| Distinct | 995 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35921.127 |
| Minimum | 603 |
|---|---|
| Maximum | 99205 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 603 |
|---|---|
| 5-th percentile | 725 |
| Q1 | 725 |
| median | 19380 |
| Q3 | 78207 |
| 95-th percentile | 94538 |
| Maximum | 99205 |
| Range | 98602 |
| Interquartile range (IQR) | 77482 |
Descriptive statistics
| Standard deviation | 37542.461 |
|---|---|
| Coefficient of variation (CV) | 1.045136 |
| Kurtosis | -1.4514194 |
| Mean | 35921.127 |
| Median Absolute Deviation (MAD) | 18655 |
| Skewness | 0.49088341 |
| Sum | 6.4843381 × 109 |
| Variance | 1.4094364 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 725 | 66770 | |
| 921 | 337 | 0.2% |
| 23455 | 334 | 0.2% |
| 957 | 297 | 0.2% |
| 79109 | 292 | 0.2% |
| 33324 | 283 | 0.2% |
| 80012 | 280 | 0.2% |
| 33624 | 261 | 0.1% |
| 92115 | 256 | 0.1% |
| 92024 | 254 | 0.1% |
| Other values (985) | 111152 |
| Value | Count | Frequency (%) |
| 603 | 50 | < 0.1% |
| 612 | 122 | 0.1% |
| 674 | 169 | 0.1% |
| 680 | 133 | 0.1% |
| 685 | 126 | 0.1% |
| 693 | 140 | 0.1% |
| 698 | 115 | 0.1% |
| 725 | 66770 | |
| 728 | 22 | < 0.1% |
| 729 | 48 | < 0.1% |
| Value | Count | Frequency (%) |
| 99205 | 43 | < 0.1% |
| 98632 | 67 | < 0.1% |
| 98390 | 28 | < 0.1% |
| 98226 | 47 | < 0.1% |
| 98208 | 95 | |
| 98115 | 185 | |
| 98052 | 117 | |
| 98037 | 82 | |
| 98031 | 158 | |
| 98023 | 98 |
Department Id
Real number (ℝ)
HIGH CORRELATION
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.4434602 |
| Minimum | 2 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 5 |
| Q3 | 7 |
| 95-th percentile | 7 |
| Maximum | 12 |
| Range | 10 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.629246 |
|---|---|
| Coefficient of variation (CV) | 0.29930338 |
| Kurtosis | -0.18169651 |
| Mean | 5.4434602 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.27332063 |
| Sum | 982648 |
| Variance | 2.6544426 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 7 | 66861 | |
| 4 | 48998 | |
| 5 | 33220 | |
| 3 | 14525 | 8.0% |
| 6 | 9686 | 5.4% |
| 2 | 2479 | 1.4% |
| 9 | 2026 | 1.1% |
| 10 | 1465 | 0.8% |
| 11 | 492 | 0.3% |
| 8 | 405 | 0.2% |
| Value | Count | Frequency (%) |
| 2 | 2479 | 1.4% |
| 3 | 14525 | 8.0% |
| 4 | 48998 | |
| 5 | 33220 | |
| 6 | 9686 | 5.4% |
| 7 | 66861 | |
| 8 | 405 | 0.2% |
| 9 | 2026 | 1.1% |
| 10 | 1465 | 0.8% |
| 11 | 492 | 0.3% |
| Value | Count | Frequency (%) |
| 12 | 362 | 0.2% |
| 11 | 492 | 0.3% |
| 10 | 1465 | 0.8% |
| 9 | 2026 | 1.1% |
| 8 | 405 | 0.2% |
| 7 | 66861 | |
| 6 | 9686 | 5.4% |
| 5 | 33220 | |
| 4 | 48998 | |
| 3 | 14525 | 8.0% |
Department Name
Categorical
HIGH CORRELATION
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Fan Shop | |
|---|---|
| Apparel | |
| Golf | |
| Footwear | |
| Outdoors | |
| Other values (6) |
Length
| Max length | 18 |
|---|---|
| Median length | 8 |
| Mean length | 7.0397133 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1270802 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Fitness |
|---|---|
| 2nd row | Fitness |
| 3rd row | Fitness |
| 4th row | Fitness |
| 5th row | Fitness |
Common Values
| Value | Count | Frequency (%) |
| Fan Shop | 66861 | |
| Apparel | 48998 | |
| Golf | 33220 | |
| Footwear | 14525 | 8.0% |
| Outdoors | 9686 | 5.4% |
| Fitness | 2479 | 1.4% |
| Discs Shop | 2026 | 1.1% |
| Technology | 1465 | 0.8% |
| Pet Shop | 492 | 0.3% |
| Book Shop | 405 | 0.2% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| shop | 69784 | |
| fan | 66861 | |
| apparel | 48998 | |
| golf | 33220 | |
| footwear | 14525 | 5.8% |
| outdoors | 9686 | 3.9% |
| fitness | 2479 | 1.0% |
| discs | 2026 | 0.8% |
| technology | 1465 | 0.6% |
| pet | 492 | 0.2% |
| Other values (4) | 1491 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 167780 | |
| o | 155166 | |
| a | 131470 | |
| l | 84045 | 6.6% |
| F | 83865 | 6.6% |
| r | 73209 | 5.8% |
| h | 71611 | 5.6% |
| n | 71167 | 5.6% |
| 70870 | 5.6% | |
| S | 69784 | 5.5% |
| Other values (20) | 291835 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 949267 | |
| Uppercase Letter | 250665 | 19.7% |
| Space Separator | 70870 | 5.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| p | 167780 | |
| o | 155166 | |
| a | 131470 | |
| l | 84045 | |
| r | 73209 | |
| h | 71611 | |
| n | 71167 | |
| e | 68683 | |
| f | 33220 | 3.5% |
| t | 27906 | 2.9% |
| Other values (9) | 65010 | 6.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 83865 | |
| S | 69784 | |
| A | 48998 | |
| G | 33220 | 13.3% |
| O | 9686 | 3.9% |
| D | 2026 | 0.8% |
| T | 1465 | 0.6% |
| B | 767 | 0.3% |
| P | 492 | 0.2% |
| H | 362 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 70870 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1199932 | |
| Common | 70870 | 5.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| p | 167780 | |
| o | 155166 | |
| a | 131470 | |
| l | 84045 | 7.0% |
| F | 83865 | 7.0% |
| r | 73209 | 6.1% |
| h | 71611 | 6.0% |
| n | 71167 | 5.9% |
| S | 69784 | 5.8% |
| e | 68683 | 5.7% |
| Other values (19) | 223152 |
Common
| Value | Count | Frequency (%) |
| 70870 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1270802 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| p | 167780 | |
| o | 155166 | |
| a | 131470 | |
| l | 84045 | 6.6% |
| F | 83865 | 6.6% |
| r | 73209 | 5.8% |
| h | 71611 | 5.6% |
| n | 71167 | 5.6% |
| 70870 | 5.6% | |
| S | 69784 | 5.5% |
| Other values (20) | 291835 |
Latitude
Real number (ℝ)
HIGH CORRELATION
| Distinct | 11250 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.719955 |
| Minimum | -33.937553 |
|---|---|
| Maximum | 48.781933 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 9 |
| Negative (%) | < 0.1% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -33.937553 |
|---|---|
| 5-th percentile | 18.212931 |
| Q1 | 18.265432 |
| median | 33.144863 |
| Q3 | 39.279617 |
| 95-th percentile | 42.391102 |
| Maximum | 48.781933 |
| Range | 82.719486 |
| Interquartile range (IQR) | 21.014185 |
Descriptive statistics
| Standard deviation | 9.8136463 |
|---|---|
| Coefficient of variation (CV) | 0.33020395 |
| Kurtosis | -1.5554149 |
| Mean | 29.719955 |
| Median Absolute Deviation (MAD) | 8.3017807 |
| Skewness | -0.097962666 |
| Sum | 5365016.5 |
| Variance | 96.307654 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 18.2275734 | 417 | 0.2% |
| 39.49591446 | 370 | 0.2% |
| 18.22757721 | 300 | 0.2% |
| 36.91083145 | 280 | 0.2% |
| 26.0984993 | 270 | 0.1% |
| 18.38011932 | 267 | 0.1% |
| 33.04647064 | 234 | 0.1% |
| 26.21472931 | 218 | 0.1% |
| 32.75856018 | 218 | 0.1% |
| 40.64759827 | 212 | 0.1% |
| Other values (11240) | 177733 |
| Value | Count | Frequency (%) |
| -33.93755341 | 9 | < 0.1% |
| 17.98249054 | 38 | |
| 18.00682068 | 22 | |
| 18.01836205 | 20 | |
| 18.02520371 | 17 | |
| 18.02520943 | 10 | < 0.1% |
| 18.02523232 | 8 | < 0.1% |
| 18.02528 | 14 | < 0.1% |
| 18.02529907 | 30 | |
| 18.02535057 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 48.78193283 | 6 | < 0.1% |
| 48.77095795 | 41 | |
| 47.92603684 | 7 | < 0.1% |
| 47.91250229 | 4 | < 0.1% |
| 47.90813828 | 20 | < 0.1% |
| 47.90808868 | 10 | < 0.1% |
| 47.88882828 | 61 | |
| 47.84322357 | 70 | |
| 47.83976364 | 15 | < 0.1% |
| 47.83055496 | 6 | < 0.1% |
Longitude
Real number (ℝ)
HIGH CORRELATION
| Distinct | 4487 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -84.915675 |
| Minimum | -158.02599 |
|---|---|
| Maximum | 115.26308 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 180414 |
| Negative (%) | 99.9% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -158.02599 |
|---|---|
| 5-th percentile | -121.43511 |
| Q1 | -98.446312 |
| median | -76.847908 |
| Q3 | -66.370583 |
| 95-th percentile | -66.183128 |
| Maximum | 115.26308 |
| Range | 273.28906 |
| Interquartile range (IQR) | 32.075729 |
Descriptive statistics
| Standard deviation | 21.433241 |
|---|---|
| Coefficient of variation (CV) | -0.25240618 |
| Kurtosis | 2.1809822 |
| Mean | -84.915675 |
| Median Absolute Deviation (MAD) | 10.477371 |
| Skewness | -0.49846107 |
| Sum | -15328893 |
| Variance | 459.38383 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -66.3706131 | 3821 | 2.1% |
| -66.37057495 | 3523 | 2.0% |
| -66.37059021 | 3522 | 2.0% |
| -66.37050629 | 3465 | 1.9% |
| -66.37055206 | 3417 | 1.9% |
| -66.37052918 | 3408 | 1.9% |
| -66.3705368 | 3377 | 1.9% |
| -66.37055969 | 3242 | 1.8% |
| -66.37060547 | 3230 | 1.8% |
| -66.37058258 | 3155 | 1.7% |
| Other values (4477) | 146359 |
| Value | Count | Frequency (%) |
| -158.0259857 | 73 | |
| -158.016037 | 134 | |
| -158.0102234 | 18 | < 0.1% |
| -158.0047607 | 7 | < 0.1% |
| -158.0046844 | 43 | < 0.1% |
| -158.0046234 | 45 | < 0.1% |
| -157.9980164 | 40 | < 0.1% |
| -157.997879 | 46 | < 0.1% |
| -157.906601 | 60 | |
| -157.8772125 | 35 | < 0.1% |
| Value | Count | Frequency (%) |
| 115.2630768 | 17 | |
| 115.0497894 | 17 | |
| 84.74267578 | 8 | < 0.1% |
| 82.46199799 | 22 | |
| 77.09209442 | 32 | |
| 18.57143784 | 9 | < 0.1% |
| -12.1069355 | 9 | < 0.1% |
| -12.13093758 | 33 | |
| -12.13232708 | 11 | < 0.1% |
| -12.25018311 | 18 |
Market
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| LATAM | |
|---|---|
| Europe | |
| Pacific Asia | |
| USCA | |
| Africa |
Length
| Max length | 12 |
|---|---|
| Median length | 6 |
| Mean length | 6.7997385 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1227482 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Pacific Asia |
|---|---|
| 2nd row | Pacific Asia |
| 3rd row | Pacific Asia |
| 4th row | Pacific Asia |
| 5th row | Pacific Asia |
Common Values
| Value | Count | Frequency (%) |
| LATAM | 51594 | |
| Europe | 50252 | |
| Pacific Asia | 41260 | |
| USCA | 25799 | |
| Africa | 11614 | 6.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| latam | 51594 | |
| europe | 50252 | |
| pacific | 41260 | |
| asia | 41260 | |
| usca | 25799 | |
| africa | 11614 | 5.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 181861 | |
| i | 135394 | 11.0% |
| a | 94134 | 7.7% |
| c | 94134 | 7.7% |
| r | 61866 | 5.0% |
| f | 52874 | 4.3% |
| L | 51594 | 4.2% |
| T | 51594 | 4.2% |
| M | 51594 | 4.2% |
| E | 50252 | 4.1% |
| Other values (10) | 402185 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 680670 | |
| Uppercase Letter | 505552 | |
| Space Separator | 41260 | 3.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 135394 | |
| a | 94134 | |
| c | 94134 | |
| r | 61866 | |
| f | 52874 | 7.8% |
| u | 50252 | 7.4% |
| o | 50252 | 7.4% |
| p | 50252 | 7.4% |
| e | 50252 | 7.4% |
| s | 41260 | 6.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 181861 | |
| L | 51594 | 10.2% |
| T | 51594 | 10.2% |
| M | 51594 | 10.2% |
| E | 50252 | 9.9% |
| P | 41260 | 8.2% |
| U | 25799 | 5.1% |
| S | 25799 | 5.1% |
| C | 25799 | 5.1% |
Space Separator
| Value | Count | Frequency (%) |
| 41260 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1186222 | |
| Common | 41260 | 3.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 181861 | |
| i | 135394 | 11.4% |
| a | 94134 | 7.9% |
| c | 94134 | 7.9% |
| r | 61866 | 5.2% |
| f | 52874 | 4.5% |
| L | 51594 | 4.3% |
| T | 51594 | 4.3% |
| M | 51594 | 4.3% |
| E | 50252 | 4.2% |
| Other values (9) | 360925 |
Common
| Value | Count | Frequency (%) |
| 41260 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1227482 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 181861 | |
| i | 135394 | 11.0% |
| a | 94134 | 7.7% |
| c | 94134 | 7.7% |
| r | 61866 | 5.0% |
| f | 52874 | 4.3% |
| L | 51594 | 4.2% |
| T | 51594 | 4.2% |
| M | 51594 | 4.2% |
| E | 50252 | 4.1% |
| Other values (10) | 402185 |
Order City
Text
| Distinct | 3597 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 35 |
|---|---|
| Median length | 29 |
| Mean length | 8.5542131 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1544198 |
|---|---|
| Distinct characters | 79 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 69 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Bekasi |
|---|---|
| 2nd row | Bikaner |
| 3rd row | Bikaner |
| 4th row | Townsville |
| 5th row | Townsville |
| Value | Count | Frequency (%) |
| san | 6508 | 2.9% |
| city | 5626 | 2.5% |
| de | 3211 | 1.4% |
| los | 2435 | 1.1% |
| santo | 2339 | 1.0% |
| new | 2316 | 1.0% |
| york | 2316 | 1.0% |
| domingo | 2239 | 1.0% |
| angeles | 1857 | 0.8% |
| tegucigalpa | 1783 | 0.8% |
| Other values (3768) | 197270 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 197677 | 12.8% |
| e | 116504 | 7.5% |
| n | 115087 | 7.5% |
| o | 111297 | 7.2% |
| i | 94427 | 6.1% |
| r | 85703 | 5.6% |
| l | 76707 | 5.0% |
| u | 57916 | 3.8% |
| t | 56384 | 3.7% |
| s | 56123 | 3.6% |
| Other values (69) | 576373 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1264434 | |
| Uppercase Letter | 225693 | 14.6% |
| Space Separator | 47381 | 3.1% |
| Dash Punctuation | 5982 | 0.4% |
| Other Punctuation | 659 | < 0.1% |
| Open Punctuation | 21 | < 0.1% |
| Close Punctuation | 21 | < 0.1% |
| Control | 7 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 197677 | |
| e | 116504 | 9.2% |
| n | 115087 | 9.1% |
| o | 111297 | 8.8% |
| i | 94427 | 7.5% |
| r | 85703 | 6.8% |
| l | 76707 | 6.1% |
| u | 57916 | 4.6% |
| t | 56384 | 4.5% |
| s | 56123 | 4.4% |
| Other values (32) | 296609 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 28079 | |
| C | 25625 | |
| M | 23445 | 10.4% |
| B | 16591 | 7.4% |
| P | 15223 | 6.7% |
| L | 14772 | 6.5% |
| A | 13507 | 6.0% |
| T | 10236 | 4.5% |
| D | 9031 | 4.0% |
| N | 7965 | 3.5% |
| Other values (19) | 61219 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 509 | |
| ? | 137 | 20.8% |
| . | 13 | 2.0% |
Space Separator
| Value | Count | Frequency (%) |
| 47381 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5982 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 21 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 21 |
Control
| Value | Count | Frequency (%) |
| | 7 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1490127 | |
| Common | 54071 | 3.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 197677 | 13.3% |
| e | 116504 | 7.8% |
| n | 115087 | 7.7% |
| o | 111297 | 7.5% |
| i | 94427 | 6.3% |
| r | 85703 | 5.8% |
| l | 76707 | 5.1% |
| u | 57916 | 3.9% |
| t | 56384 | 3.8% |
| s | 56123 | 3.8% |
| Other values (61) | 522302 |
Common
| Value | Count | Frequency (%) |
| 47381 | ||
| - | 5982 | 11.1% |
| ' | 509 | 0.9% |
| ? | 137 | 0.3% |
| ( | 21 | < 0.1% |
| ) | 21 | < 0.1% |
| . | 13 | < 0.1% |
| | 7 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1528572 | |
| None | 15626 | 1.0% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 197677 | 12.9% |
| e | 116504 | 7.6% |
| n | 115087 | 7.5% |
| o | 111297 | 7.3% |
| i | 94427 | 6.2% |
| r | 85703 | 5.6% |
| l | 76707 | 5.0% |
| u | 57916 | 3.8% |
| t | 56384 | 3.7% |
| s | 56123 | 3.7% |
| Other values (49) | 560747 |
None
| Value | Count | Frequency (%) |
| í | 4201 | |
| á | 4180 | |
| ó | 2167 | |
| é | 1466 | 9.4% |
| ã | 1354 | 8.7% |
| ú | 1170 | 7.5% |
| ç | 279 | 1.8% |
| ü | 259 | 1.7% |
| ñ | 166 | 1.1% |
| Á | 148 | 0.9% |
| Other values (10) | 236 | 1.5% |
Order Country
Text
| Distinct | 164 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 31 |
|---|---|
| Median length | 22 |
| Mean length | 8.7728272 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1583662 |
|---|---|
| Distinct characters | 61 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Indonesia |
|---|---|
| 2nd row | India |
| 3rd row | India |
| 4th row | Australia |
| 5th row | Australia |
| Value | Count | Frequency (%) |
| unidos | 24869 | 10.8% |
| estados | 24840 | 10.8% |
| francia | 13222 | 5.7% |
| méxico | 13172 | 5.7% |
| alemania | 9564 | 4.1% |
| australia | 8497 | 3.7% |
| brasil | 7987 | 3.5% |
| reino | 7302 | 3.2% |
| unido | 7302 | 3.2% |
| china | 5758 | 2.5% |
| Other values (175) | 108034 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 241810 | |
| i | 166236 | 10.5% |
| n | 119798 | 7.6% |
| s | 117962 | 7.4% |
| o | 109660 | 6.9% |
| d | 83403 | 5.3% |
| r | 66669 | 4.2% |
| l | 62119 | 3.9% |
| e | 53254 | 3.4% |
| t | 50532 | 3.2% |
| Other values (51) | 512219 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1303170 | |
| Uppercase Letter | 229618 | 14.5% |
| Space Separator | 50028 | 3.2% |
| Open Punctuation | 409 | < 0.1% |
| Close Punctuation | 409 | < 0.1% |
| Dash Punctuation | 28 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 241810 | |
| i | 166236 | |
| n | 119798 | |
| s | 117962 | |
| o | 109660 | |
| d | 83403 | 6.4% |
| r | 66669 | 5.1% |
| l | 62119 | 4.8% |
| e | 53254 | 4.1% |
| t | 50532 | 3.9% |
| Other values (22) | 231727 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 34032 | |
| U | 33494 | |
| A | 24433 | |
| I | 17168 | |
| M | 16328 | |
| F | 15635 | |
| C | 15397 | |
| R | 13800 | 6.0% |
| B | 12369 | 5.4% |
| S | 8781 | 3.8% |
| Other values (15) | 38181 |
Space Separator
| Value | Count | Frequency (%) |
| 50028 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 409 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 409 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 28 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1532788 | |
| Common | 50874 | 3.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 241810 | |
| i | 166236 | 10.8% |
| n | 119798 | 7.8% |
| s | 117962 | 7.7% |
| o | 109660 | 7.2% |
| d | 83403 | 5.4% |
| r | 66669 | 4.3% |
| l | 62119 | 4.1% |
| e | 53254 | 3.5% |
| t | 50532 | 3.3% |
| Other values (47) | 461345 |
Common
| Value | Count | Frequency (%) |
| 50028 | ||
| ( | 409 | 0.8% |
| ) | 409 | 0.8% |
| - | 28 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1545222 | |
| None | 38440 | 2.4% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 241810 | |
| i | 166236 | 10.8% |
| n | 119798 | 7.8% |
| s | 117962 | 7.6% |
| o | 109660 | 7.1% |
| d | 83403 | 5.4% |
| r | 66669 | 4.3% |
| l | 62119 | 4.0% |
| e | 53254 | 3.4% |
| t | 50532 | 3.3% |
| Other values (44) | 473779 |
None
| Value | Count | Frequency (%) |
| é | 14306 | |
| í | 7138 | |
| á | 6253 | |
| ú | 6043 | |
| ñ | 3868 | 10.1% |
| ó | 803 | 2.1% |
| Á | 29 | 0.1% |
Order Customer Id
Real number (ℝ)
HIGH CORRELATION
| Distinct | 20652 |
|---|---|
| Distinct (%) | 11.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6691.3795 |
| Minimum | 1 |
|---|---|
| Maximum | 20757 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 649 |
| Q1 | 3258.5 |
| median | 6457 |
| Q3 | 9779 |
| 95-th percentile | 12383 |
| Maximum | 20757 |
| Range | 20756 |
| Interquartile range (IQR) | 6520.5 |
Descriptive statistics
| Standard deviation | 4162.9181 |
|---|---|
| Coefficient of variation (CV) | 0.62213152 |
| Kurtosis | 0.014898822 |
| Mean | 6691.3795 |
| Median Absolute Deviation (MAD) | 3263 |
| Skewness | 0.48876825 |
| Sum | 1.2079211 × 109 |
| Variance | 17329887 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5654 | 47 | < 0.1% |
| 10591 | 45 | < 0.1% |
| 5004 | 45 | < 0.1% |
| 5715 | 44 | < 0.1% |
| 3708 | 44 | < 0.1% |
| 9371 | 44 | < 0.1% |
| 1443 | 43 | < 0.1% |
| 791 | 43 | < 0.1% |
| 12284 | 43 | < 0.1% |
| 2641 | 43 | < 0.1% |
| Other values (20642) | 180078 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2 | 10 | |
| 3 | 18 | |
| 4 | 14 | |
| 5 | 7 | < 0.1% |
| 6 | 15 | |
| 7 | 22 | |
| 8 | 19 | |
| 9 | 14 | |
| 10 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 20757 | 1 | |
| 20756 | 1 | |
| 20755 | 1 | |
| 20754 | 1 | |
| 20753 | 1 | |
| 20752 | 1 | |
| 20751 | 1 | |
| 20750 | 1 | |
| 20749 | 1 | |
| 20748 | 1 |
| Distinct | 65752 |
|---|---|
| Distinct (%) | 36.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Minimum | 2015-01-01 00:00:00 |
|---|---|
| Maximum | 2018-01-31 23:38:00 |
Histogram with fixed size bins (bins=50)
Order Id
Real number (ℝ)
HIGH CORRELATION
| Distinct | 65752 |
|---|---|
| Distinct (%) | 36.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36221.895 |
| Minimum | 1 |
|---|---|
| Maximum | 77204 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3626.8 |
| Q1 | 18057 |
| median | 36140 |
| Q3 | 54144 |
| 95-th percentile | 68596 |
| Maximum | 77204 |
| Range | 77203 |
| Interquartile range (IQR) | 36087 |
Descriptive statistics
| Standard deviation | 21045.38 |
|---|---|
| Coefficient of variation (CV) | 0.58101266 |
| Kurtosis | -1.1529357 |
| Mean | 36221.895 |
| Median Absolute Deviation (MAD) | 18042 |
| Skewness | 0.032708795 |
| Sum | 6.5387402 × 109 |
| Variance | 4.42908 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 48880 | 5 | < 0.1% |
| 3605 | 5 | < 0.1% |
| 28265 | 5 | < 0.1% |
| 50037 | 5 | < 0.1% |
| 27861 | 5 | < 0.1% |
| 23412 | 5 | < 0.1% |
| 27068 | 5 | < 0.1% |
| 27717 | 5 | < 0.1% |
| 47273 | 5 | < 0.1% |
| 27914 | 5 | < 0.1% |
| Other values (65742) | 180469 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2 | 3 | |
| 4 | 4 | |
| 5 | 5 | |
| 7 | 3 | |
| 8 | 4 | |
| 9 | 3 | |
| 10 | 5 | |
| 11 | 5 | |
| 12 | 5 |
| Value | Count | Frequency (%) |
| 77204 | 1 | |
| 77203 | 1 | |
| 77202 | 1 | |
| 77201 | 1 | |
| 77200 | 1 | |
| 77199 | 1 | |
| 77198 | 1 | |
| 77197 | 1 | |
| 77196 | 1 | |
| 77195 | 1 |
Order Item Cardprod Id
Real number (ℝ)
HIGH CORRELATION
| Distinct | 118 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 692.50976 |
| Minimum | 19 |
|---|---|
| Maximum | 1363 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 191 |
| Q1 | 403 |
| median | 627 |
| Q3 | 1004 |
| 95-th percentile | 1073 |
| Maximum | 1363 |
| Range | 1344 |
| Interquartile range (IQR) | 601 |
Descriptive statistics
| Standard deviation | 336.44681 |
|---|---|
| Coefficient of variation (CV) | 0.48583692 |
| Kurtosis | -1.2674939 |
| Mean | 692.50976 |
| Median Absolute Deviation (MAD) | 330 |
| Skewness | 0.13825461 |
| Sum | 1.2501117 × 108 |
| Variance | 113196.45 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 365 | 24515 | |
| 403 | 22246 | |
| 502 | 21035 | |
| 1014 | 19298 | |
| 1004 | 17325 | |
| 1073 | 15500 | |
| 957 | 13729 | |
| 191 | 12169 | |
| 627 | 10617 | |
| 1362 | 838 | 0.5% |
| Other values (108) | 23247 |
| Value | Count | Frequency (%) |
| 19 | 64 | < 0.1% |
| 24 | 74 | < 0.1% |
| 35 | 65 | < 0.1% |
| 37 | 262 | |
| 44 | 305 | |
| 58 | 29 | < 0.1% |
| 60 | 10 | < 0.1% |
| 61 | 28 | < 0.1% |
| 78 | 63 | < 0.1% |
| 93 | 280 |
| Value | Count | Frequency (%) |
| 1363 | 650 | |
| 1362 | 838 | |
| 1361 | 529 | |
| 1360 | 357 | |
| 1359 | 492 | |
| 1358 | 434 | |
| 1357 | 208 | 0.1% |
| 1356 | 362 | |
| 1355 | 484 | |
| 1354 | 483 |
Order Item Discount
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 1017 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.664741 |
| Minimum | 0 |
|---|---|
| Maximum | 500 |
| Zeros | 10028 |
| Zeros (%) | 5.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5.4000001 |
| median | 14 |
| Q3 | 29.99 |
| 95-th percentile | 62.5 |
| Maximum | 500 |
| Range | 500 |
| Interquartile range (IQR) | 24.59 |
Descriptive statistics
| Standard deviation | 21.800901 |
|---|---|
| Coefficient of variation (CV) | 1.0549806 |
| Kurtosis | 25.231267 |
| Mean | 20.664741 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 3.0397955 |
| Sum | 3730378.4 |
| Variance | 475.27928 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 10028 | 5.6% |
| 6 | 4589 | 2.5% |
| 12 | 4067 | 2.3% |
| 4 | 3647 | 2.0% |
| 8 | 3626 | 2.0% |
| 10 | 3424 | 1.9% |
| 36 | 3268 | 1.8% |
| 30 | 3230 | 1.8% |
| 20 | 3123 | 1.7% |
| 9 | 2964 | 1.6% |
| Other values (1007) | 138553 |
| Value | Count | Frequency (%) |
| 0 | 10028 | |
| 0.100000001 | 3 | < 0.1% |
| 0.109999999 | 15 | < 0.1% |
| 0.119999997 | 29 | < 0.1% |
| 0.150000006 | 7 | < 0.1% |
| 0.159999996 | 7 | < 0.1% |
| 0.180000007 | 3 | < 0.1% |
| 0.200000003 | 16 | < 0.1% |
| 0.219999999 | 6 | < 0.1% |
| 0.230000004 | 44 | < 0.1% |
| Value | Count | Frequency (%) |
| 500 | 1 | < 0.1% |
| 400 | 1 | < 0.1% |
| 375 | 25 | |
| 360 | 1 | < 0.1% |
| 340 | 1 | < 0.1% |
| 320 | 1 | < 0.1% |
| 300 | 26 | |
| 270 | 25 | |
| 260 | 1 | < 0.1% |
| 255 | 25 |
Order Item Discount Rate
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.10166819 |
| Minimum | 0 |
|---|---|
| Maximum | 0.25 |
| Zeros | 10028 |
| Zeros (%) | 5.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.039999999 |
| median | 0.1 |
| Q3 | 0.16 |
| 95-th percentile | 0.25 |
| Maximum | 0.25 |
| Range | 0.25 |
| Interquartile range (IQR) | 0.12 |
Descriptive statistics
| Standard deviation | 0.070415215 |
|---|---|
| Coefficient of variation (CV) | 0.69259829 |
| Kurtosis | -0.90115686 |
| Mean | 0.10166819 |
| Median Absolute Deviation (MAD) | 0.059999995 |
| Skewness | 0.3409276 |
| Sum | 18353.04 |
| Variance | 0.0049583025 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) |
| 0.039999999 | 10029 | 5.6% |
| 0.150000006 | 10029 | 5.6% |
| 0.25 | 10029 | 5.6% |
| 0.200000003 | 10029 | 5.6% |
| 0.180000007 | 10029 | 5.6% |
| 0.170000002 | 10029 | 5.6% |
| 0.050000001 | 10029 | 5.6% |
| 0.159999996 | 10029 | 5.6% |
| 0.129999995 | 10029 | 5.6% |
| 0.119999997 | 10029 | 5.6% |
| Other values (8) | 80229 |
| Value | Count | Frequency (%) |
| 0 | 10028 | |
| 0.01 | 10028 | |
| 0.02 | 10028 | |
| 0.029999999 | 10029 | |
| 0.039999999 | 10029 | |
| 0.050000001 | 10029 | |
| 0.059999999 | 10029 | |
| 0.07 | 10029 | |
| 0.090000004 | 10029 | |
| 0.100000001 | 10029 |
| Value | Count | Frequency (%) |
| 0.25 | 10029 | |
| 0.200000003 | 10029 | |
| 0.180000007 | 10029 | |
| 0.170000002 | 10029 | |
| 0.159999996 | 10029 | |
| 0.150000006 | 10029 | |
| 0.129999995 | 10029 | |
| 0.119999997 | 10029 | |
| 0.100000001 | 10029 | |
| 0.090000004 | 10029 |
Order Item Id
Real number (ℝ)
HIGH CORRELATION UNIFORM UNIQUE
| Distinct | 180519 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90260 |
| Minimum | 1 |
|---|---|
| Maximum | 180519 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9026.9 |
| Q1 | 45130.5 |
| median | 90260 |
| Q3 | 135389.5 |
| 95-th percentile | 171493.1 |
| Maximum | 180519 |
| Range | 180518 |
| Interquartile range (IQR) | 90259 |
Descriptive statistics
| Standard deviation | 52111.491 |
|---|---|
| Coefficient of variation (CV) | 0.57734867 |
| Kurtosis | -1.2 |
| Mean | 90260 |
| Median Absolute Deviation (MAD) | 45130 |
| Skewness | 8.4554661 × 10-18 |
| Sum | 1.6293645 × 1010 |
| Variance | 2.7156075 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 180517 | 1 | < 0.1% |
| 42681 | 1 | < 0.1% |
| 28953 | 1 | < 0.1% |
| 39851 | 1 | < 0.1% |
| 173601 | 1 | < 0.1% |
| 46791 | 1 | < 0.1% |
| 166889 | 1 | < 0.1% |
| 31184 | 1 | < 0.1% |
| 29248 | 1 | < 0.1% |
| 161714 | 1 | < 0.1% |
| Other values (180509) | 180509 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 180519 | 1 | |
| 180518 | 1 | |
| 180517 | 1 | |
| 180516 | 1 | |
| 180515 | 1 | |
| 180514 | 1 | |
| 180513 | 1 | |
| 180512 | 1 | |
| 180511 | 1 | |
| 180510 | 1 |
Order Item Product Price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 75 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 141.23255 |
| Minimum | 9.9899998 |
|---|---|
| Maximum | 1999.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 9.9899998 |
|---|---|
| 5-th percentile | 31.99 |
| Q1 | 50 |
| median | 59.990002 |
| Q3 | 199.99001 |
| 95-th percentile | 399.98001 |
| Maximum | 1999.99 |
| Range | 1990 |
| Interquartile range (IQR) | 149.99001 |
Descriptive statistics
| Standard deviation | 139.73249 |
|---|---|
| Coefficient of variation (CV) | 0.98937881 |
| Kurtosis | 23.312997 |
| Mean | 141.23255 |
| Median Absolute Deviation (MAD) | 39.999996 |
| Skewness | 3.1910196 |
| Sum | 25495159 |
| Variance | 19525.169 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 59.99000168 | 24820 | |
| 129.9900055 | 22372 | |
| 50 | 21035 | |
| 49.97999954 | 19298 | |
| 399.980011 | 17325 | |
| 199.9900055 | 15622 | |
| 299.980011 | 13729 | |
| 99.98999786 | 12433 | |
| 39.99000168 | 11201 | |
| 24.98999977 | 2339 | 1.3% |
| Other values (65) | 20345 |
| Value | Count | Frequency (%) |
| 9.989999771 | 285 | 0.2% |
| 11.28999996 | 271 | 0.2% |
| 11.53999996 | 529 | 0.3% |
| 14.98999977 | 593 | 0.3% |
| 15.98999977 | 602 | 0.3% |
| 17.98999977 | 298 | 0.2% |
| 19.98999977 | 887 | 0.5% |
| 21.98999977 | 295 | 0.2% |
| 22 | 308 | 0.2% |
| 24.98999977 | 2339 |
| Value | Count | Frequency (%) |
| 1999.98999 | 15 | < 0.1% |
| 1500 | 442 | 0.2% |
| 999.9899902 | 10 | < 0.1% |
| 599.9899902 | 21 | < 0.1% |
| 532.5800171 | 484 | 0.3% |
| 461.480011 | 484 | 0.3% |
| 452.0400085 | 592 | 0.3% |
| 399.9899902 | 67 | < 0.1% |
| 399.980011 | 17325 | |
| 357.1000061 | 652 | 0.4% |
Order Item Profit Ratio
Real number (ℝ)
HIGH CORRELATION
| Distinct | 162 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.12064664 |
| Minimum | -2.75 |
|---|---|
| Maximum | 0.5 |
| Zeros | 1177 |
| Zeros (%) | 0.7% |
| Negative | 33784 |
| Negative (%) | 18.7% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -2.75 |
|---|---|
| 5-th percentile | -0.76999998 |
| Q1 | 0.079999998 |
| median | 0.27000001 |
| Q3 | 0.36000001 |
| 95-th percentile | 0.47999999 |
| Maximum | 0.5 |
| Range | 3.25 |
| Interquartile range (IQR) | 0.28000002 |
Descriptive statistics
| Standard deviation | 0.4667956 |
|---|---|
| Coefficient of variation (CV) | 3.8691142 |
| Kurtosis | 10.157225 |
| Mean | 0.12064664 |
| Median Absolute Deviation (MAD) | 0.16999999 |
| Skewness | -2.8935313 |
| Sum | 21779.01 |
| Variance | 0.21789814 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.479999989 | 9197 | 5.1% |
| 0.349999994 | 7997 | 4.4% |
| 0.25999999 | 6577 | 3.6% |
| 0.340000004 | 6507 | 3.6% |
| 0.469999999 | 6378 | 3.5% |
| 0.360000014 | 6108 | 3.4% |
| 0.330000013 | 5789 | 3.2% |
| 0.49000001 | 5688 | 3.2% |
| 0.289999992 | 5478 | 3.0% |
| 0.280000001 | 5403 | 3.0% |
| Other values (152) | 115397 |
| Value | Count | Frequency (%) |
| -2.75 | 72 | < 0.1% |
| -2.700000048 | 252 | |
| -2.650000095 | 90 | < 0.1% |
| -2.599999905 | 181 | |
| -2.549999952 | 234 | |
| -2.5 | 180 | |
| -2.450000048 | 18 | < 0.1% |
| -2.349999905 | 36 | < 0.1% |
| -2.299999952 | 18 | < 0.1% |
| -2.25 | 36 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.5 | 2529 | 1.4% |
| 0.49000001 | 5688 | |
| 0.479999989 | 9197 | |
| 0.469999999 | 6378 | |
| 0.460000008 | 4822 | |
| 0.449999988 | 3973 | |
| 0.439999998 | 1390 | 0.8% |
| 0.430000007 | 1085 | 0.6% |
| 0.419999987 | 1245 | 0.7% |
| 0.409999996 | 995 | 0.6% |
Order Item Quantity
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 1 | |
|---|---|
| 5 | |
| 3 | |
| 4 | |
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 180519 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 180519 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 180519 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 180519 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 99134 | |
| 5 | 20385 | 11.3% |
| 3 | 20350 | 11.3% |
| 4 | 20335 | 11.3% |
| 2 | 20315 | 11.3% |
Sales
Real number (ℝ)
HIGH CORRELATION
| Distinct | 193 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203.7721 |
| Minimum | 9.9899998 |
|---|---|
| Maximum | 1999.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 9.9899998 |
|---|---|
| 5-th percentile | 49.98 |
| Q1 | 119.98 |
| median | 199.92 |
| Q3 | 299.95001 |
| 95-th percentile | 399.98001 |
| Maximum | 1999.99 |
| Range | 1990 |
| Interquartile range (IQR) | 179.97001 |
Descriptive statistics
| Standard deviation | 132.27308 |
|---|---|
| Coefficient of variation (CV) | 0.64912262 |
| Kurtosis | 23.936561 |
| Mean | 203.7721 |
| Median Absolute Deviation (MAD) | 79.939995 |
| Skewness | 2.884249 |
| Sum | 36784735 |
| Variance | 17496.167 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 129.9900055 | 22372 | 12.4% |
| 399.980011 | 17325 | 9.6% |
| 199.9900055 | 15622 | 8.7% |
| 299.980011 | 13729 | 7.6% |
| 179.9700012 | 5016 | 2.8% |
| 299.9500122 | 4988 | 2.8% |
| 119.9800034 | 4968 | 2.8% |
| 239.9600067 | 4955 | 2.7% |
| 59.99000168 | 4893 | 2.7% |
| 50 | 4432 | 2.5% |
| Other values (183) | 82219 |
| Value | Count | Frequency (%) |
| 9.989999771 | 56 | < 0.1% |
| 11.28999996 | 271 | |
| 11.53999996 | 529 | |
| 14.98999977 | 124 | 0.1% |
| 15.98999977 | 118 | 0.1% |
| 17.98999977 | 62 | < 0.1% |
| 19.97999954 | 54 | < 0.1% |
| 19.98999977 | 176 | 0.1% |
| 21.98999977 | 51 | < 0.1% |
| 22 | 64 | < 0.1% |
| Value | Count | Frequency (%) |
| 1999.98999 | 15 | < 0.1% |
| 1500 | 442 | 0.2% |
| 999.9899902 | 10 | < 0.1% |
| 599.9899902 | 21 | < 0.1% |
| 532.5800171 | 484 | 0.3% |
| 500 | 15 | < 0.1% |
| 499.9500122 | 2510 | |
| 499.75 | 12 | < 0.1% |
| 495 | 14 | < 0.1% |
| 474.9500122 | 15 | < 0.1% |
Order Item Total
Real number (ℝ)
HIGH CORRELATION
| Distinct | 2927 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 183.10761 |
| Minimum | 7.4899998 |
|---|---|
| Maximum | 1939.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 7.4899998 |
|---|---|
| 5-th percentile | 41.5 |
| Q1 | 104.38 |
| median | 163.99001 |
| Q3 | 247.39999 |
| 95-th percentile | 383.98001 |
| Maximum | 1939.99 |
| Range | 1932.5 |
| Interquartile range (IQR) | 143.02 |
Descriptive statistics
| Standard deviation | 120.04367 |
|---|---|
| Coefficient of variation (CV) | 0.65559084 |
| Kurtosis | 23.920362 |
| Mean | 183.10761 |
| Median Absolute Deviation (MAD) | 67.000008 |
| Skewness | 2.8884461 |
| Sum | 33054402 |
| Variance | 14410.483 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 122.8399963 | 1264 | 0.7% |
| 109.1900024 | 1247 | 0.7% |
| 124.7900009 | 1243 | 0.7% |
| 129.9900055 | 1243 | 0.7% |
| 116.9899979 | 1243 | 0.7% |
| 123.4899979 | 1243 | 0.7% |
| 120.8899994 | 1243 | 0.7% |
| 127.3899994 | 1243 | 0.7% |
| 97.48999786 | 1243 | 0.7% |
| 118.2900009 | 1243 | 0.7% |
| Other values (2917) | 168064 |
| Value | Count | Frequency (%) |
| 7.489999771 | 3 | < 0.1% |
| 7.989999771 | 3 | < 0.1% |
| 8.18999958 | 3 | < 0.1% |
| 8.289999962 | 3 | < 0.1% |
| 8.390000343 | 3 | < 0.1% |
| 8.470000267 | 15 | |
| 8.489999771 | 3 | < 0.1% |
| 8.659999847 | 29 | |
| 8.68999958 | 3 | < 0.1% |
| 8.789999962 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 1939.98999 | 1 | |
| 1919.98999 | 1 | |
| 1899.98999 | 1 | |
| 1889.98999 | 1 | |
| 1859.98999 | 1 | |
| 1819.98999 | 1 | |
| 1799.98999 | 1 | |
| 1759.98999 | 1 | |
| 1739.98999 | 1 | |
| 1699.98999 | 1 |
Order Profit Per Order
Real number (ℝ)
HIGH CORRELATION
| Distinct | 21998 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.974989 |
| Minimum | -4274.98 |
|---|---|
| Maximum | 911.79999 |
| Zeros | 1177 |
| Zeros (%) | 0.7% |
| Negative | 33784 |
| Negative (%) | 18.7% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -4274.98 |
|---|---|
| 5-th percentile | -139.251 |
| Q1 | 7 |
| median | 31.52 |
| Q3 | 64.800003 |
| 95-th percentile | 132.28999 |
| Maximum | 911.79999 |
| Range | 5186.78 |
| Interquartile range (IQR) | 57.800003 |
Descriptive statistics
| Standard deviation | 104.43353 |
|---|---|
| Coefficient of variation (CV) | 4.7523813 |
| Kurtosis | 71.377259 |
| Mean | 21.974989 |
| Median Absolute Deviation (MAD) | 27.88 |
| Skewness | -4.7418341 |
| Sum | 3966903 |
| Variance | 10906.361 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1177 | 0.7% |
| 143.9900055 | 199 | 0.1% |
| 72 | 194 | 0.1% |
| 46.79999924 | 188 | 0.1% |
| 24 | 181 | 0.1% |
| 18 | 175 | 0.1% |
| 63.70000076 | 172 | 0.1% |
| 62.40000153 | 168 | 0.1% |
| 12 | 166 | 0.1% |
| 14.39999962 | 166 | 0.1% |
| Other values (21988) | 177733 |
| Value | Count | Frequency (%) |
| -4274.97998 | 1 | |
| -3442.5 | 1 | |
| -3366 | 1 | |
| -3000 | 1 | |
| -2592 | 1 | |
| -2550 | 1 | |
| -2351.25 | 1 | |
| -2328 | 1 | |
| -2280 | 1 | |
| -2255.25 | 1 |
| Value | Count | Frequency (%) |
| 911.7999878 | 1 | |
| 864 | 1 | |
| 721.5999756 | 1 | |
| 720.2999878 | 1 | |
| 720 | 2 | |
| 712.9500122 | 1 | |
| 708.75 | 1 | |
| 705.5999756 | 2 | |
| 705 | 1 | |
| 698.4000244 | 2 |
Order Region
Categorical
HIGH CORRELATION
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Central America | |
|---|---|
| Western Europe | |
| South America | |
| Oceania | |
| Northern Europe | |
| Other values (18) |
Length
| Max length | 15 |
|---|---|
| Median length | 14 |
| Mean length | 12.634304 |
| Min length | 6 |
Characters and Unicode
| Total characters | 2280732 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Southeast Asia |
|---|---|
| 2nd row | South Asia |
| 3rd row | South Asia |
| 4th row | Oceania |
| 5th row | Oceania |
Common Values
| Value | Count | Frequency (%) |
| Central America | 28341 | |
| Western Europe | 27109 | |
| South America | 14935 | 8.3% |
| Oceania | 10148 | 5.6% |
| Northern Europe | 9792 | 5.4% |
| Southeast Asia | 9539 | 5.3% |
| Southern Europe | 9431 | 5.2% |
| Caribbean | 8318 | 4.6% |
| West of USA | 7993 | 4.4% |
| South Asia | 7731 | 4.3% |
| Other values (13) | 47182 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| europe | 50252 | |
| america | 43276 | |
| asia | 31112 | 8.6% |
| central | 30571 | 8.5% |
| western | 27109 | 7.5% |
| south | 26711 | 7.4% |
| of | 18953 | 5.3% |
| usa | 18953 | 5.3% |
| west | 17698 | 4.9% |
| africa | 11614 | 3.2% |
| Other values (11) | 84317 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 267374 | 11.7% |
| r | 221631 | 9.7% |
| 202017 | 8.9% | |
| a | 185888 | 8.2% |
| t | 170633 | 7.5% |
| o | 129067 | 5.7% |
| n | 114572 | 5.0% |
| s | 105425 | 4.6% |
| A | 104955 | 4.6% |
| i | 104468 | 4.6% |
| Other values (16) | 674702 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1693309 | |
| Uppercase Letter | 385406 | 16.9% |
| Space Separator | 202017 | 8.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 267374 | |
| r | 221631 | |
| a | 185888 | |
| t | 170633 | |
| o | 129067 | |
| n | 114572 | |
| s | 105425 | 6.2% |
| i | 104468 | 6.2% |
| u | 97090 | 5.7% |
| c | 65038 | 3.8% |
| Other values (7) | 232123 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 104955 | |
| S | 71678 | |
| E | 70219 | |
| C | 45735 | |
| W | 44807 | |
| U | 24840 | 6.4% |
| N | 13024 | 3.4% |
| O | 10148 | 2.6% |
Space Separator
| Value | Count | Frequency (%) |
| 202017 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2078715 | |
| Common | 202017 | 8.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 267374 | |
| r | 221631 | 10.7% |
| a | 185888 | 8.9% |
| t | 170633 | 8.2% |
| o | 129067 | 6.2% |
| n | 114572 | 5.5% |
| s | 105425 | 5.1% |
| A | 104955 | 5.0% |
| i | 104468 | 5.0% |
| u | 97090 | 4.7% |
| Other values (15) | 577612 |
Common
| Value | Count | Frequency (%) |
| 202017 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2280732 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 267374 | 11.7% |
| r | 221631 | 9.7% |
| 202017 | 8.9% | |
| a | 185888 | 8.2% |
| t | 170633 | 7.5% |
| o | 129067 | 5.7% |
| n | 114572 | 5.0% |
| s | 105425 | 4.6% |
| A | 104955 | 4.6% |
| i | 104468 | 4.6% |
| Other values (16) | 674702 |
Order State
Text
| Distinct | 1089 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 36 |
|---|---|
| Median length | 31 |
| Mean length | 10.872617 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1962714 |
|---|---|
| Distinct characters | 83 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 16 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Java Occidental |
|---|---|
| 2nd row | Rajastán |
| 3rd row | Rajastán |
| 4th row | Queensland |
| 5th row | Queensland |
| Value | Count | Frequency (%) |
| de | 9121 | 3.5% |
| del | 8417 | 3.2% |
| inglaterra | 6722 | 2.5% |
| california | 5580 | 2.1% |
| nueva | 5473 | 2.1% |
| isla | 4667 | 1.8% |
| francia | 4580 | 1.7% |
| san | 3965 | 1.5% |
| sur | 3354 | 1.3% |
| norte-westfalia | 3303 | 1.3% |
| Other values (1171) | 208627 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 310562 | |
| n | 142494 | 7.3% |
| i | 131317 | 6.7% |
| e | 131085 | 6.7% |
| r | 117395 | 6.0% |
| o | 114621 | 5.8% |
| l | 103549 | 5.3% |
| 83290 | 4.2% | |
| t | 80118 | 4.1% |
| s | 75596 | 3.9% |
| Other values (73) | 672687 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1584761 | |
| Uppercase Letter | 268229 | 13.7% |
| Space Separator | 83290 | 4.2% |
| Dash Punctuation | 24466 | 1.2% |
| Open Punctuation | 664 | < 0.1% |
| Close Punctuation | 664 | < 0.1% |
| Other Punctuation | 627 | < 0.1% |
| Control | 13 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 310562 | |
| n | 142494 | |
| i | 131317 | |
| e | 131085 | |
| r | 117395 | 7.4% |
| o | 114621 | 7.2% |
| l | 103549 | 6.5% |
| t | 80118 | 5.1% |
| s | 75596 | 4.8% |
| u | 62262 | 3.9% |
| Other values (35) | 315762 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 30372 | 11.3% |
| S | 27262 | 10.2% |
| A | 20489 | 7.6% |
| P | 18540 | 6.9% |
| M | 16660 | 6.2% |
| N | 16027 | 6.0% |
| I | 14188 | 5.3% |
| B | 12615 | 4.7% |
| G | 12427 | 4.6% |
| L | 11348 | 4.2% |
| Other values (20) | 88301 |
Other Punctuation
| Value | Count | Frequency (%) |
| ? | 503 | |
| ' | 124 | 19.8% |
Control
| Value | Count | Frequency (%) |
| | 8 | |
| | 5 |
Space Separator
| Value | Count | Frequency (%) |
| 83290 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 24466 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 664 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 664 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1852990 | |
| Common | 109724 | 5.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 310562 | |
| n | 142494 | 7.7% |
| i | 131317 | 7.1% |
| e | 131085 | 7.1% |
| r | 117395 | 6.3% |
| o | 114621 | 6.2% |
| l | 103549 | 5.6% |
| t | 80118 | 4.3% |
| s | 75596 | 4.1% |
| u | 62262 | 3.4% |
| Other values (65) | 583991 |
Common
| Value | Count | Frequency (%) |
| 83290 | ||
| - | 24466 | 22.3% |
| ( | 664 | 0.6% |
| ) | 664 | 0.6% |
| ? | 503 | 0.5% |
| ' | 124 | 0.1% |
| | 8 | < 0.1% |
| | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1925211 | |
| None | 37503 | 1.9% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 310562 | |
| n | 142494 | 7.4% |
| i | 131317 | 6.8% |
| e | 131085 | 6.8% |
| r | 117395 | 6.1% |
| o | 114621 | 6.0% |
| l | 103549 | 5.4% |
| 83290 | 4.3% | |
| t | 80118 | 4.2% |
| s | 75596 | 3.9% |
| Other values (48) | 635184 |
None
| Value | Count | Frequency (%) |
| í | 11965 | |
| á | 10023 | |
| ó | 4698 | 12.5% |
| é | 3332 | 8.9% |
| ñ | 3173 | 8.5% |
| ã | 2031 | 5.4% |
| ú | 918 | 2.4% |
| ü | 380 | 1.0% |
| à | 171 | 0.5% |
| ô | 168 | 0.4% |
| Other values (15) | 644 | 1.7% |
Order Status
Categorical
HIGH CORRELATION
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| COMPLETE | |
|---|---|
| PENDING_PAYMENT | |
| PROCESSING | |
| PENDING | |
| CLOSED | |
| Other values (4) |
Length
| Max length | 15 |
|---|---|
| Median length | 14 |
| Mean length | 9.6239676 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1737309 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | COMPLETE |
|---|---|
| 2nd row | PENDING |
| 3rd row | CLOSED |
| 4th row | COMPLETE |
| 5th row | PENDING_PAYMENT |
Common Values
| Value | Count | Frequency (%) |
| COMPLETE | 59491 | |
| PENDING_PAYMENT | 39832 | |
| PROCESSING | 21902 | 12.1% |
| PENDING | 20227 | 11.2% |
| CLOSED | 19616 | 10.9% |
| ON_HOLD | 9804 | 5.4% |
| SUSPECTED_FRAUD | 4062 | 2.3% |
| CANCELED | 3692 | 2.0% |
| PAYMENT_REVIEW | 1893 | 1.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| complete | 59491 | |
| pending_payment | 39832 | |
| processing | 21902 | 12.1% |
| pending | 20227 | 11.2% |
| closed | 19616 | 10.9% |
| on_hold | 9804 | 5.4% |
| suspected_fraud | 4062 | 2.3% |
| canceled | 3692 | 2.0% |
| payment_review | 1893 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 281578 | |
| N | 197241 | |
| P | 187239 | |
| O | 120617 | 6.9% |
| C | 112455 | 6.5% |
| T | 105278 | 6.1% |
| D | 101295 | 5.8% |
| M | 101216 | 5.8% |
| L | 92603 | 5.3% |
| I | 83854 | 4.8% |
| Other values (11) | 353933 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1681718 | |
| Connector Punctuation | 55591 | 3.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 281578 | |
| N | 197241 | |
| P | 187239 | |
| O | 120617 | |
| C | 112455 | 6.7% |
| T | 105278 | 6.3% |
| D | 101295 | 6.0% |
| M | 101216 | 6.0% |
| L | 92603 | 5.5% |
| I | 83854 | 5.0% |
| Other values (10) | 298342 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 55591 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1681718 | |
| Common | 55591 | 3.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 281578 | |
| N | 197241 | |
| P | 187239 | |
| O | 120617 | |
| C | 112455 | 6.7% |
| T | 105278 | 6.3% |
| D | 101295 | 6.0% |
| M | 101216 | 6.0% |
| L | 92603 | 5.5% |
| I | 83854 | 5.0% |
| Other values (10) | 298342 |
Common
| Value | Count | Frequency (%) |
| _ | 55591 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1737309 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 281578 | |
| N | 197241 | |
| P | 187239 | |
| O | 120617 | 6.9% |
| C | 112455 | 6.5% |
| T | 105278 | 6.1% |
| D | 101295 | 5.8% |
| M | 101216 | 5.8% |
| L | 92603 | 5.3% |
| I | 83854 | 4.8% |
| Other values (11) | 353933 |
Order Zipcode
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 609 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 155679 |
| Missing (%) | 86.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55426.132 |
| Minimum | 1040 |
|---|---|
| Maximum | 99301 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1040 |
|---|---|
| 5-th percentile | 10009 |
| Q1 | 23464 |
| median | 59405 |
| Q3 | 90008 |
| 95-th percentile | 98026 |
| Maximum | 99301 |
| Range | 98261 |
| Interquartile range (IQR) | 66544 |
Descriptive statistics
| Standard deviation | 31919.279 |
|---|---|
| Coefficient of variation (CV) | 0.57588862 |
| Kurtosis | -1.4817345 |
| Mean | 55426.132 |
| Median Absolute Deviation (MAD) | 30631 |
| Skewness | -0.1403114 |
| Sum | 1.3767851 × 109 |
| Variance | 1.0188404 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10035 | 648 | 0.4% |
| 10009 | 550 | 0.3% |
| 10024 | 541 | 0.3% |
| 94122 | 526 | 0.3% |
| 10011 | 463 | 0.3% |
| 94110 | 407 | 0.2% |
| 98105 | 406 | 0.2% |
| 19140 | 386 | 0.2% |
| 90049 | 368 | 0.2% |
| 98103 | 366 | 0.2% |
| Other values (599) | 20179 | 11.2% |
| (Missing) | 155679 |
| Value | Count | Frequency (%) |
| 1040 | 3 | < 0.1% |
| 1453 | 17 | < 0.1% |
| 1752 | 6 | < 0.1% |
| 1810 | 13 | < 0.1% |
| 1841 | 88 | |
| 1852 | 38 | |
| 1915 | 2 | < 0.1% |
| 2038 | 39 | |
| 2138 | 14 | < 0.1% |
| 2148 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99301 | 10 | < 0.1% |
| 99207 | 22 | < 0.1% |
| 98661 | 12 | < 0.1% |
| 98632 | 10 | < 0.1% |
| 98502 | 9 | < 0.1% |
| 98270 | 3 | < 0.1% |
| 98226 | 3 | < 0.1% |
| 98208 | 5 | < 0.1% |
| 98198 | 17 | < 0.1% |
| 98115 | 294 |
Product Card Id
Real number (ℝ)
HIGH CORRELATION
| Distinct | 118 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 692.50976 |
| Minimum | 19 |
|---|---|
| Maximum | 1363 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 191 |
| Q1 | 403 |
| median | 627 |
| Q3 | 1004 |
| 95-th percentile | 1073 |
| Maximum | 1363 |
| Range | 1344 |
| Interquartile range (IQR) | 601 |
Descriptive statistics
| Standard deviation | 336.44681 |
|---|---|
| Coefficient of variation (CV) | 0.48583692 |
| Kurtosis | -1.2674939 |
| Mean | 692.50976 |
| Median Absolute Deviation (MAD) | 330 |
| Skewness | 0.13825461 |
| Sum | 1.2501117 × 108 |
| Variance | 113196.45 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 365 | 24515 | |
| 403 | 22246 | |
| 502 | 21035 | |
| 1014 | 19298 | |
| 1004 | 17325 | |
| 1073 | 15500 | |
| 957 | 13729 | |
| 191 | 12169 | |
| 627 | 10617 | |
| 1362 | 838 | 0.5% |
| Other values (108) | 23247 |
| Value | Count | Frequency (%) |
| 19 | 64 | < 0.1% |
| 24 | 74 | < 0.1% |
| 35 | 65 | < 0.1% |
| 37 | 262 | |
| 44 | 305 | |
| 58 | 29 | < 0.1% |
| 60 | 10 | < 0.1% |
| 61 | 28 | < 0.1% |
| 78 | 63 | < 0.1% |
| 93 | 280 |
| Value | Count | Frequency (%) |
| 1363 | 650 | |
| 1362 | 838 | |
| 1361 | 529 | |
| 1360 | 357 | |
| 1359 | 492 | |
| 1358 | 434 | |
| 1357 | 208 | 0.1% |
| 1356 | 362 | |
| 1355 | 484 | |
| 1354 | 483 |
Product Category Id
Real number (ℝ)
HIGH CORRELATION
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.851451 |
| Minimum | 2 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 18 |
| median | 29 |
| Q3 | 45 |
| 95-th percentile | 48 |
| Maximum | 76 |
| Range | 74 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 15.640064 |
|---|---|
| Coefficient of variation (CV) | 0.49103145 |
| Kurtosis | -0.60326101 |
| Mean | 31.851451 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 0.3616248 |
| Sum | 5749792 |
| Variance | 244.6116 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 17 | 24551 | |
| 18 | 22246 | |
| 24 | 21035 | |
| 46 | 19298 | |
| 45 | 17325 | |
| 48 | 15540 | |
| 43 | 13729 | |
| 9 | 12487 | |
| 29 | 10984 | |
| 37 | 2029 | 1.1% |
| Other values (41) | 21295 |
| Value | Count | Frequency (%) |
| 2 | 138 | 0.1% |
| 3 | 632 | 0.4% |
| 4 | 67 | < 0.1% |
| 5 | 343 | 0.2% |
| 6 | 328 | 0.2% |
| 7 | 614 | 0.3% |
| 9 | 12487 | |
| 10 | 111 | 0.1% |
| 11 | 309 | 0.2% |
| 12 | 423 | 0.2% |
| Value | Count | Frequency (%) |
| 76 | 650 | |
| 75 | 838 | |
| 74 | 529 | |
| 73 | 357 | |
| 72 | 492 | |
| 71 | 434 | |
| 70 | 208 | 0.1% |
| 69 | 362 | |
| 68 | 484 | |
| 67 | 483 |
Product Description
Unsupported
MISSING REJECTED UNSUPPORTED
| Missing | 180519 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 1.4 MiB |
Product Image
Text
| Distinct | 118 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 94 |
|---|---|
| Median length | 90 |
| Mean length | 69.947014 |
| Min length | 36 |
Characters and Unicode
| Total characters | 12626765 |
|---|---|
| Distinct characters | 66 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | http://images.acmesports.sports/Smart+watch |
|---|---|
| 2nd row | http://images.acmesports.sports/Smart+watch |
| 3rd row | http://images.acmesports.sports/Smart+watch |
| 4th row | http://images.acmesports.sports/Smart+watch |
| 5th row | http://images.acmesports.sports/Smart+watch |
| Value | Count | Frequency (%) |
| http://images.acmesports.sports/perfect+fitness+perfect+rip+deck | 24515 | |
| http://images.acmesports.sports/nike+men%27s+cj+elite+2+td+football+cleat | 22246 | |
| http://images.acmesports.sports/nike+men%27s+dri-fit+victory+golf+polo | 21035 | |
| http://images.acmesports.sports/o%27brien+men%27s+neoprene+life+vest | 19298 | |
| http://images.acmesports.sports/field+%26+stream+sportsman+16+gun+fire+safe | 17325 | |
| http://images.acmesports.sports/pelican+sunstream+100+kayak | 15500 | |
| http://images.acmesports.sports/diamondback+women%27s+serene+classic+comfort+bike+2014 | 13729 | |
| http://images.acmesports.sports/nike+men%27s+free+5.0%2b+running+shoe | 12169 | |
| http://images.acmesports.sports/under+armour+girls%27+toddler+spine+surge+running+shoe | 10617 | |
| http://images.acmesports.sports/fighting+video+games | 838 | 0.5% |
| Other values (108) | 23247 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 1166577 | 9.2% |
| e | 1121625 | 8.9% |
| t | 997512 | 7.9% |
| + | 913711 | 7.2% |
| r | 703683 | 5.6% |
| o | 666883 | 5.3% |
| p | 620629 | 4.9% |
| a | 593978 | 4.7% |
| i | 559394 | 4.4% |
| / | 541557 | 4.3% |
| Other values (56) | 4741216 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8804395 | |
| Other Punctuation | 1255258 | 9.9% |
| Uppercase Letter | 1137901 | 9.0% |
| Math Symbol | 913711 | 7.2% |
| Decimal Number | 491276 | 3.9% |
| Dash Punctuation | 23338 | 0.2% |
| Space Separator | 886 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 137110 | |
| F | 120346 | |
| P | 93021 | 8.2% |
| D | 85981 | 7.6% |
| M | 81289 | 7.1% |
| N | 79408 | 7.0% |
| C | 78303 | 6.9% |
| T | 64674 | 5.7% |
| G | 63324 | 5.6% |
| B | 52566 | 4.6% |
| Other values (15) | 281879 |
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 1166577 | |
| e | 1121625 | |
| t | 997512 | |
| r | 703683 | |
| o | 666883 | |
| p | 620629 | |
| a | 593978 | 6.7% |
| i | 559394 | 6.4% |
| m | 481927 | 5.5% |
| n | 361861 | 4.1% |
| Other values (14) | 1530326 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 193261 | |
| 7 | 126306 | |
| 0 | 58520 | 11.9% |
| 1 | 48714 | 9.9% |
| 6 | 35961 | 7.3% |
| 4 | 14542 | 3.0% |
| 5 | 12729 | 2.6% |
| 3 | 643 | 0.1% |
| 8 | 555 | 0.1% |
| 9 | 45 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 541557 | |
| . | 376918 | |
| : | 180519 | 14.4% |
| % | 156264 | 12.4% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 913711 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 23338 |
Space Separator
| Value | Count | Frequency (%) |
| 886 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9942296 | |
| Common | 2684469 | 21.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 1166577 | |
| e | 1121625 | |
| t | 997512 | 10.0% |
| r | 703683 | 7.1% |
| o | 666883 | 6.7% |
| p | 620629 | 6.2% |
| a | 593978 | 6.0% |
| i | 559394 | 5.6% |
| m | 481927 | 4.8% |
| n | 361861 | 3.6% |
| Other values (39) | 2668227 |
Common
| Value | Count | Frequency (%) |
| + | 913711 | |
| / | 541557 | |
| . | 376918 | |
| 2 | 193261 | 7.2% |
| : | 180519 | 6.7% |
| % | 156264 | 5.8% |
| 7 | 126306 | 4.7% |
| 0 | 58520 | 2.2% |
| 1 | 48714 | 1.8% |
| 6 | 35961 | 1.3% |
| Other values (7) | 52738 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12626765 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 1166577 | 9.2% |
| e | 1121625 | 8.9% |
| t | 997512 | 7.9% |
| + | 913711 | 7.2% |
| r | 703683 | 5.6% |
| o | 666883 | 5.3% |
| p | 620629 | 4.9% |
| a | 593978 | 4.7% |
| i | 559394 | 4.4% |
| / | 541557 | 4.3% |
| Other values (56) | 4741216 |
Product Name
Text
| Distinct | 118 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 45 |
|---|---|
| Median length | 43 |
| Mean length | 35.120004 |
| Min length | 5 |
Characters and Unicode
| Total characters | 6339828 |
|---|---|
| Distinct characters | 66 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Smart watch |
|---|---|
| 2nd row | Smart watch |
| 3rd row | Smart watch |
| 4th row | Smart watch |
| 5th row | Smart watch |
| Value | Count | Frequency (%) |
| men's | 77602 | 7.3% |
| nike | 57309 | 5.4% |
| perfect | 49030 | 4.6% |
| golf | 26281 | 2.5% |
| rip | 24515 | 2.3% |
| deck | 24515 | 2.3% |
| fitness | 24515 | 2.3% |
| cleat | 22813 | 2.1% |
| 2 | 22574 | 2.1% |
| elite | 22309 | 2.1% |
| Other values (351) | 715106 |
Most occurring characters
| Value | Count | Frequency (%) |
| 887824 | 14.0% | |
| e | 733504 | 11.6% |
| i | 378177 | 6.0% |
| n | 350567 | 5.5% |
| r | 340664 | 5.4% |
| o | 293733 | 4.6% |
| t | 274503 | 4.3% |
| s | 263028 | 4.1% |
| l | 230952 | 3.6% |
| a | 230847 | 3.6% |
| Other values (56) | 2356029 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4011603 | |
| Uppercase Letter | 1110988 | 17.5% |
| Space Separator | 887824 | 14.0% |
| Other Punctuation | 157902 | 2.5% |
| Decimal Number | 136270 | 2.1% |
| Dash Punctuation | 23040 | 0.4% |
| Math Symbol | 12201 | 0.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 126137 | |
| F | 119900 | |
| P | 92713 | 8.3% |
| D | 85981 | 7.7% |
| M | 81289 | 7.3% |
| N | 79408 | 7.1% |
| C | 77993 | 7.0% |
| T | 64000 | 5.8% |
| G | 62759 | 5.6% |
| R | 50142 | 4.5% |
| Other values (15) | 270666 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 733504 | |
| i | 378177 | |
| n | 350567 | |
| r | 340664 | |
| o | 293733 | 7.3% |
| t | 274503 | 6.8% |
| s | 263028 | 6.6% |
| l | 230952 | 5.8% |
| a | 230847 | 5.8% |
| c | 150579 | 3.8% |
| Other values (14) | 765049 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 44762 | |
| 1 | 34956 | |
| 2 | 23239 | |
| 6 | 18574 | |
| 5 | 12729 | 9.3% |
| 4 | 756 | 0.6% |
| 3 | 643 | 0.5% |
| 8 | 555 | 0.4% |
| 9 | 45 | < 0.1% |
| 7 | 11 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 127155 | |
| & | 17387 | 11.0% |
| . | 12979 | 8.2% |
| / | 381 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 887824 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 23040 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 12201 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5122591 | |
| Common | 1217237 | 19.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 733504 | 14.3% |
| i | 378177 | 7.4% |
| n | 350567 | 6.8% |
| r | 340664 | 6.7% |
| o | 293733 | 5.7% |
| t | 274503 | 5.4% |
| s | 263028 | 5.1% |
| l | 230952 | 4.5% |
| a | 230847 | 4.5% |
| c | 150579 | 2.9% |
| Other values (39) | 1876037 |
Common
| Value | Count | Frequency (%) |
| 887824 | ||
| ' | 127155 | 10.4% |
| 0 | 44762 | 3.7% |
| 1 | 34956 | 2.9% |
| 2 | 23239 | 1.9% |
| - | 23040 | 1.9% |
| 6 | 18574 | 1.5% |
| & | 17387 | 1.4% |
| . | 12979 | 1.1% |
| 5 | 12729 | 1.0% |
| Other values (7) | 14592 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6339828 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 887824 | 14.0% | |
| e | 733504 | 11.6% |
| i | 378177 | 6.0% |
| n | 350567 | 5.5% |
| r | 340664 | 5.4% |
| o | 293733 | 4.6% |
| t | 274503 | 4.3% |
| s | 263028 | 4.1% |
| l | 230952 | 3.6% |
| a | 230847 | 3.6% |
| Other values (56) | 2356029 |
Product Price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 75 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 141.23255 |
| Minimum | 9.9899998 |
|---|---|
| Maximum | 1999.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 9.9899998 |
|---|---|
| 5-th percentile | 31.99 |
| Q1 | 50 |
| median | 59.990002 |
| Q3 | 199.99001 |
| 95-th percentile | 399.98001 |
| Maximum | 1999.99 |
| Range | 1990 |
| Interquartile range (IQR) | 149.99001 |
Descriptive statistics
| Standard deviation | 139.73249 |
|---|---|
| Coefficient of variation (CV) | 0.98937881 |
| Kurtosis | 23.312997 |
| Mean | 141.23255 |
| Median Absolute Deviation (MAD) | 39.999996 |
| Skewness | 3.1910196 |
| Sum | 25495159 |
| Variance | 19525.169 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 59.99000168 | 24820 | |
| 129.9900055 | 22372 | |
| 50 | 21035 | |
| 49.97999954 | 19298 | |
| 399.980011 | 17325 | |
| 199.9900055 | 15622 | |
| 299.980011 | 13729 | |
| 99.98999786 | 12433 | |
| 39.99000168 | 11201 | |
| 24.98999977 | 2339 | 1.3% |
| Other values (65) | 20345 |
| Value | Count | Frequency (%) |
| 9.989999771 | 285 | 0.2% |
| 11.28999996 | 271 | 0.2% |
| 11.53999996 | 529 | 0.3% |
| 14.98999977 | 593 | 0.3% |
| 15.98999977 | 602 | 0.3% |
| 17.98999977 | 298 | 0.2% |
| 19.98999977 | 887 | 0.5% |
| 21.98999977 | 295 | 0.2% |
| 22 | 308 | 0.2% |
| 24.98999977 | 2339 |
| Value | Count | Frequency (%) |
| 1999.98999 | 15 | < 0.1% |
| 1500 | 442 | 0.2% |
| 999.9899902 | 10 | < 0.1% |
| 599.9899902 | 21 | < 0.1% |
| 532.5800171 | 484 | 0.3% |
| 461.480011 | 484 | 0.3% |
| 452.0400085 | 592 | 0.3% |
| 399.9899902 | 67 | < 0.1% |
| 399.980011 | 17325 | |
| 357.1000061 | 652 | 0.4% |
Product Status
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 180519 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 180519 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 180519 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 180519 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 180519 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 180519 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 180519 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 180519 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 180519 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 180519 |
| Distinct | 63701 |
|---|---|
| Distinct (%) | 35.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Minimum | 2015-01-03 00:00:00 |
|---|---|
| Maximum | 2018-02-06 22:14:00 |
Histogram with fixed size bins (bins=50)
Shipping Mode
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 9737 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.823969 |
| Min length | 8 |
Characters and Unicode
| Total characters | 2314970 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Standard Class |
|---|---|
| 2nd row | Standard Class |
| 3rd row | Standard Class |
| 4th row | Standard Class |
| 5th row | Standard Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 107752 | |
| Second Class | 35216 | 19.5% |
| First Class | 27814 | 15.4% |
| Same Day | 9737 | 5.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 170782 | |
| standard | 107752 | |
| second | 35216 | 9.8% |
| first | 27814 | 7.7% |
| same | 9737 | 2.7% |
| day | 9737 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 405760 | |
| s | 369378 | |
| d | 250720 | |
| 180519 | ||
| l | 170782 | |
| C | 170782 | |
| S | 152705 | 6.6% |
| n | 142968 | 6.2% |
| r | 135566 | 5.9% |
| t | 135566 | 5.9% |
| Other values (8) | 200224 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1773413 | |
| Uppercase Letter | 361038 | 15.6% |
| Space Separator | 180519 | 7.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 405760 | |
| s | 369378 | |
| d | 250720 | |
| l | 170782 | |
| n | 142968 | 8.1% |
| r | 135566 | 7.6% |
| t | 135566 | 7.6% |
| e | 44953 | 2.5% |
| c | 35216 | 2.0% |
| o | 35216 | 2.0% |
| Other values (3) | 47288 | 2.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 170782 | |
| S | 152705 | |
| F | 27814 | 7.7% |
| D | 9737 | 2.7% |
Space Separator
| Value | Count | Frequency (%) |
| 180519 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2134451 | |
| Common | 180519 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 405760 | |
| s | 369378 | |
| d | 250720 | |
| l | 170782 | |
| C | 170782 | |
| S | 152705 | 7.2% |
| n | 142968 | 6.7% |
| r | 135566 | 6.4% |
| t | 135566 | 6.4% |
| e | 44953 | 2.1% |
| Other values (7) | 155271 | 7.3% |
Common
| Value | Count | Frequency (%) |
| 180519 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2314970 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 405760 | |
| s | 369378 | |
| d | 250720 | |
| 180519 | ||
| l | 170782 | |
| C | 170782 | |
| S | 152705 | 6.6% |
| n | 142968 | 6.2% |
| r | 135566 | 5.9% |
| t | 135566 | 5.9% |
| Other values (8) | 200224 |
| Days for shipping (real) | Benefit per order | Sales per customer | Category Id | Customer Id | Customer Zipcode | Department Id | Latitude | Longitude | Order Customer Id | Order Id | Order Item Cardprod Id | Order Item Discount | Order Item Discount Rate | Order Item Id | Order Item Product Price | Order Item Profit Ratio | Sales | Order Item Total | Order Profit Per Order | Order Zipcode | Product Card Id | Product Category Id | Product Price | Type | Days for shipment (scheduled) | Delivery Status | Late_delivery_risk | Category Name | Customer Country | Customer Segment | Customer State | Department Name | Market | Order Item Quantity | Order Region | Order Status | Shipping Mode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Days for shipping (real) | 1.000 | -0.003 | -0.000 | -0.002 | 0.004 | -0.002 | -0.002 | -0.003 | 0.001 | 0.004 | -0.002 | -0.002 | 0.001 | 0.001 | -0.002 | -0.000 | -0.003 | -0.000 | -0.000 | -0.003 | -0.002 | -0.002 | -0.002 | -0.000 | 0.010 | 0.681 | 0.561 | 0.631 | 0.006 | 0.011 | 0.009 | 0.027 | 0.006 | 0.008 | 0.000 | 0.022 | 0.008 | 0.681 |
| Benefit per order | -0.003 | 1.000 | 0.441 | 0.061 | 0.003 | 0.002 | 0.085 | 0.002 | -0.003 | 0.003 | 0.017 | 0.060 | 0.196 | -0.054 | 0.017 | 0.287 | 0.808 | 0.436 | 0.441 | 1.000 | -0.007 | 0.060 | 0.061 | 0.287 | 0.003 | 0.002 | 0.000 | 0.000 | 0.232 | 0.000 | 0.000 | 0.011 | 0.127 | 0.021 | 0.034 | 0.014 | 0.000 | 0.002 |
| Sales per customer | -0.000 | 0.441 | 1.000 | 0.162 | 0.013 | -0.001 | 0.224 | 0.000 | 0.003 | 0.013 | 0.041 | 0.160 | 0.420 | -0.133 | 0.041 | 0.639 | -0.000 | 0.986 | 1.000 | 0.441 | -0.003 | 0.160 | 0.162 | 0.639 | 0.005 | 0.004 | 0.005 | 0.000 | 0.480 | 0.000 | 0.006 | 0.000 | 0.241 | 0.036 | 0.212 | 0.026 | 0.006 | 0.004 |
| Category Id | -0.002 | 0.061 | 0.162 | 1.000 | 0.133 | 0.002 | 0.908 | 0.002 | 0.015 | 0.133 | 0.135 | 0.998 | 0.073 | 0.000 | 0.135 | 0.195 | -0.002 | 0.178 | 0.162 | 0.061 | -0.007 | 0.998 | 1.000 | 0.195 | 0.001 | 0.009 | 0.000 | 0.000 | 0.973 | 0.000 | 0.008 | 0.008 | 0.683 | 0.158 | 0.232 | 0.118 | 0.001 | 0.009 |
| Customer Id | 0.004 | 0.003 | 0.013 | 0.133 | 1.000 | -0.000 | 0.061 | 0.006 | -0.011 | 1.000 | 0.133 | 0.133 | 0.003 | 0.002 | 0.133 | 0.039 | -0.000 | 0.014 | 0.013 | 0.003 | -0.006 | 0.133 | 0.133 | 0.039 | 0.005 | 0.009 | 0.006 | 0.004 | 0.512 | 0.015 | 0.031 | 0.050 | 0.336 | 0.179 | 0.099 | 0.134 | 0.008 | 0.009 |
| Customer Zipcode | -0.002 | 0.002 | -0.001 | 0.002 | -0.000 | 1.000 | 0.003 | 0.639 | -0.946 | -0.000 | -0.002 | 0.002 | -0.001 | -0.001 | -0.002 | 0.002 | 0.005 | -0.001 | -0.001 | 0.002 | 0.011 | 0.002 | 0.002 | 0.002 | 0.010 | 0.013 | 0.012 | 0.012 | 0.002 | 0.902 | 0.028 | 0.974 | 0.002 | 0.013 | 0.000 | 0.018 | 0.010 | 0.013 |
| Department Id | -0.002 | 0.085 | 0.224 | 0.908 | 0.061 | 0.003 | 1.000 | 0.003 | 0.004 | 0.061 | 0.063 | 0.905 | 0.102 | 0.000 | 0.063 | 0.202 | -0.003 | 0.241 | 0.224 | 0.085 | -0.006 | 0.905 | 0.908 | 0.202 | 0.000 | 0.010 | 0.001 | 0.000 | 0.993 | 0.000 | 0.006 | 0.010 | 1.000 | 0.119 | 0.240 | 0.089 | 0.001 | 0.010 |
| Latitude | -0.003 | 0.002 | 0.000 | 0.002 | 0.006 | 0.639 | 0.003 | 1.000 | -0.615 | 0.006 | -0.002 | 0.002 | -0.003 | -0.004 | -0.002 | 0.001 | 0.002 | -0.000 | 0.000 | 0.002 | -0.008 | 0.002 | 0.002 | 0.001 | 0.003 | 0.008 | 0.009 | 0.007 | 0.000 | 0.979 | 0.020 | 0.799 | 0.000 | 0.008 | 0.001 | 0.015 | 0.011 | 0.008 |
| Longitude | 0.001 | -0.003 | 0.003 | 0.015 | -0.011 | -0.946 | 0.004 | -0.615 | 1.000 | -0.011 | 0.021 | 0.015 | 0.001 | 0.000 | 0.021 | 0.004 | -0.005 | 0.003 | 0.003 | -0.003 | -0.011 | 0.015 | 0.015 | 0.004 | 0.010 | 0.010 | 0.012 | 0.010 | 0.000 | 0.806 | 0.023 | 0.644 | 0.000 | 0.013 | 0.000 | 0.018 | 0.011 | 0.010 |
| Order Customer Id | 0.004 | 0.003 | 0.013 | 0.133 | 1.000 | -0.000 | 0.061 | 0.006 | -0.011 | 1.000 | 0.133 | 0.133 | 0.003 | 0.002 | 0.133 | 0.039 | -0.000 | 0.014 | 0.013 | 0.003 | -0.006 | 0.133 | 0.133 | 0.039 | 0.005 | 0.009 | 0.006 | 0.004 | 0.512 | 0.015 | 0.031 | 0.050 | 0.336 | 0.179 | 0.099 | 0.134 | 0.008 | 0.009 |
| Order Id | -0.002 | 0.017 | 0.041 | 0.135 | 0.133 | -0.002 | 0.063 | -0.002 | 0.021 | 0.133 | 1.000 | 0.131 | 0.019 | 0.001 | 1.000 | 0.082 | 0.001 | 0.044 | 0.041 | 0.017 | 0.014 | 0.131 | 0.135 | 0.082 | 0.015 | 0.010 | 0.009 | 0.006 | 0.337 | 0.012 | 0.006 | 0.026 | 0.242 | 0.753 | 0.098 | 0.551 | 0.012 | 0.010 |
| Order Item Cardprod Id | -0.002 | 0.060 | 0.160 | 0.998 | 0.133 | 0.002 | 0.905 | 0.002 | 0.015 | 0.133 | 0.131 | 1.000 | 0.072 | 0.001 | 0.131 | 0.192 | -0.002 | 0.176 | 0.160 | 0.060 | -0.007 | 1.000 | 0.998 | 0.192 | 0.000 | 0.000 | 0.000 | 0.000 | 0.984 | 0.000 | 0.000 | 0.008 | 0.784 | 0.129 | 0.242 | 0.105 | 0.000 | 0.000 |
| Order Item Discount | 0.001 | 0.196 | 0.420 | 0.073 | 0.003 | -0.001 | 0.102 | -0.003 | 0.001 | 0.003 | 0.019 | 0.072 | 1.000 | 0.795 | 0.019 | 0.356 | -0.002 | 0.534 | 0.420 | 0.196 | 0.000 | 0.072 | 0.073 | 0.356 | 0.000 | 0.000 | 0.000 | 0.000 | 0.302 | 0.001 | 0.002 | 0.005 | 0.162 | 0.024 | 0.082 | 0.018 | 0.000 | 0.000 |
| Order Item Discount Rate | 0.001 | -0.054 | -0.133 | 0.000 | 0.002 | -0.001 | 0.000 | -0.004 | 0.000 | 0.002 | 0.001 | 0.001 | 0.795 | 1.000 | 0.001 | 0.000 | -0.002 | 0.000 | -0.133 | -0.054 | 0.000 | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 | 0.006 | 0.000 | 0.003 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.002 | 0.000 |
| Order Item Id | -0.002 | 0.017 | 0.041 | 0.135 | 0.133 | -0.002 | 0.063 | -0.002 | 0.021 | 0.133 | 1.000 | 0.131 | 0.019 | 0.001 | 1.000 | 0.082 | 0.001 | 0.044 | 0.041 | 0.017 | 0.014 | 0.131 | 0.135 | 0.082 | 0.015 | 0.010 | 0.008 | 0.008 | 0.232 | 0.011 | 0.007 | 0.025 | 0.166 | 0.714 | 0.076 | 0.532 | 0.011 | 0.010 |
| Order Item Product Price | -0.000 | 0.287 | 0.639 | 0.195 | 0.039 | 0.002 | 0.202 | 0.001 | 0.004 | 0.039 | 0.082 | 0.192 | 0.356 | 0.000 | 0.082 | 1.000 | 0.000 | 0.667 | 0.639 | 0.287 | -0.001 | 0.192 | 0.195 | 1.000 | 0.005 | 0.008 | 0.000 | 0.004 | 0.807 | 0.000 | 0.002 | 0.000 | 0.394 | 0.059 | 0.229 | 0.060 | 0.003 | 0.008 |
| Order Item Profit Ratio | -0.003 | 0.808 | -0.000 | -0.002 | -0.000 | 0.005 | -0.003 | 0.002 | -0.005 | -0.000 | 0.001 | -0.002 | -0.002 | -0.002 | 0.001 | 0.000 | 1.000 | -0.001 | -0.000 | 0.808 | -0.006 | -0.002 | -0.002 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.002 | 0.000 | 0.000 | 0.001 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 | 0.000 |
| Sales | -0.000 | 0.436 | 0.986 | 0.178 | 0.014 | -0.001 | 0.241 | -0.000 | 0.003 | 0.014 | 0.044 | 0.176 | 0.534 | 0.000 | 0.044 | 0.667 | -0.001 | 1.000 | 0.986 | 0.436 | -0.003 | 0.176 | 0.178 | 0.667 | 0.005 | 0.006 | 0.000 | 0.002 | 0.685 | 0.000 | 0.004 | 0.000 | 0.343 | 0.042 | 0.235 | 0.042 | 0.004 | 0.006 |
| Order Item Total | -0.000 | 0.441 | 1.000 | 0.162 | 0.013 | -0.001 | 0.224 | 0.000 | 0.003 | 0.013 | 0.041 | 0.160 | 0.420 | -0.133 | 0.041 | 0.639 | -0.000 | 0.986 | 1.000 | 0.441 | -0.003 | 0.160 | 0.162 | 0.639 | 0.005 | 0.004 | 0.005 | 0.000 | 0.480 | 0.000 | 0.006 | 0.000 | 0.241 | 0.036 | 0.212 | 0.026 | 0.006 | 0.004 |
| Order Profit Per Order | -0.003 | 1.000 | 0.441 | 0.061 | 0.003 | 0.002 | 0.085 | 0.002 | -0.003 | 0.003 | 0.017 | 0.060 | 0.196 | -0.054 | 0.017 | 0.287 | 0.808 | 0.436 | 0.441 | 1.000 | -0.007 | 0.060 | 0.061 | 0.287 | 0.003 | 0.002 | 0.000 | 0.000 | 0.232 | 0.000 | 0.000 | 0.011 | 0.127 | 0.021 | 0.034 | 0.014 | 0.000 | 0.002 |
| Order Zipcode | -0.002 | -0.007 | -0.003 | -0.007 | -0.006 | 0.011 | -0.006 | -0.008 | -0.011 | -0.006 | 0.014 | -0.007 | 0.000 | 0.000 | 0.014 | -0.001 | -0.006 | -0.003 | -0.003 | -0.007 | 1.000 | -0.007 | -0.007 | -0.001 | 0.032 | 0.039 | 0.025 | 0.031 | 0.000 | 0.034 | 0.024 | 0.072 | 0.007 | 1.000 | 0.000 | 0.922 | 0.031 | 0.039 |
| Product Card Id | -0.002 | 0.060 | 0.160 | 0.998 | 0.133 | 0.002 | 0.905 | 0.002 | 0.015 | 0.133 | 0.131 | 1.000 | 0.072 | 0.001 | 0.131 | 0.192 | -0.002 | 0.176 | 0.160 | 0.060 | -0.007 | 1.000 | 0.998 | 0.192 | 0.000 | 0.000 | 0.000 | 0.000 | 0.984 | 0.000 | 0.000 | 0.008 | 0.784 | 0.129 | 0.242 | 0.105 | 0.000 | 0.000 |
| Product Category Id | -0.002 | 0.061 | 0.162 | 1.000 | 0.133 | 0.002 | 0.908 | 0.002 | 0.015 | 0.133 | 0.135 | 0.998 | 0.073 | 0.000 | 0.135 | 0.195 | -0.002 | 0.178 | 0.162 | 0.061 | -0.007 | 0.998 | 1.000 | 0.195 | 0.001 | 0.009 | 0.000 | 0.000 | 0.973 | 0.000 | 0.008 | 0.008 | 0.683 | 0.158 | 0.232 | 0.118 | 0.001 | 0.009 |
| Product Price | -0.000 | 0.287 | 0.639 | 0.195 | 0.039 | 0.002 | 0.202 | 0.001 | 0.004 | 0.039 | 0.082 | 0.192 | 0.356 | 0.000 | 0.082 | 1.000 | 0.000 | 0.667 | 0.639 | 0.287 | -0.001 | 0.192 | 0.195 | 1.000 | 0.005 | 0.008 | 0.000 | 0.004 | 0.807 | 0.000 | 0.002 | 0.000 | 0.394 | 0.059 | 0.229 | 0.060 | 0.003 | 0.008 |
| Type | 0.010 | 0.003 | 0.005 | 0.001 | 0.005 | 0.010 | 0.000 | 0.003 | 0.010 | 0.005 | 0.015 | 0.000 | 0.000 | 0.000 | 0.015 | 0.005 | 0.000 | 0.005 | 0.005 | 0.003 | 0.032 | 0.000 | 0.001 | 0.005 | 1.000 | 0.006 | 0.198 | 0.078 | 0.000 | 0.006 | 0.005 | 0.023 | 0.000 | 0.011 | 0.000 | 0.019 | 1.000 | 0.006 |
| Days for shipment (scheduled) | 0.681 | 0.002 | 0.004 | 0.009 | 0.009 | 0.013 | 0.010 | 0.008 | 0.010 | 0.009 | 0.010 | 0.000 | 0.000 | 0.000 | 0.010 | 0.008 | 0.000 | 0.006 | 0.004 | 0.002 | 0.039 | 0.000 | 0.009 | 0.008 | 0.006 | 1.000 | 0.321 | 0.457 | 0.018 | 0.009 | 0.008 | 0.027 | 0.010 | 0.007 | 0.002 | 0.023 | 0.009 | 1.000 |
| Delivery Status | 0.561 | 0.000 | 0.005 | 0.000 | 0.006 | 0.012 | 0.001 | 0.009 | 0.012 | 0.006 | 0.009 | 0.000 | 0.000 | 0.004 | 0.008 | 0.000 | 0.000 | 0.000 | 0.005 | 0.000 | 0.025 | 0.000 | 0.000 | 0.000 | 0.198 | 0.321 | 1.000 | 1.000 | 0.000 | 0.003 | 0.005 | 0.024 | 0.000 | 0.006 | 0.000 | 0.018 | 0.577 | 0.321 |
| Late_delivery_risk | 0.631 | 0.000 | 0.000 | 0.000 | 0.004 | 0.012 | 0.000 | 0.007 | 0.010 | 0.004 | 0.006 | 0.000 | 0.000 | 0.006 | 0.008 | 0.004 | 0.000 | 0.002 | 0.000 | 0.000 | 0.031 | 0.000 | 0.000 | 0.004 | 0.078 | 0.457 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.018 | 0.000 | 0.005 | 0.000 | 0.017 | 0.234 | 0.457 |
| Category Name | 0.006 | 0.232 | 0.480 | 0.973 | 0.512 | 0.002 | 0.993 | 0.000 | 0.000 | 0.512 | 0.337 | 0.984 | 0.302 | 0.000 | 0.232 | 0.807 | 0.002 | 0.685 | 0.480 | 0.232 | 0.000 | 0.984 | 0.973 | 0.807 | 0.000 | 0.018 | 0.000 | 0.000 | 1.000 | 0.000 | 0.015 | 0.008 | 0.994 | 0.176 | 0.394 | 0.084 | 0.002 | 0.018 |
| Customer Country | 0.011 | 0.000 | 0.000 | 0.000 | 0.015 | 0.902 | 0.000 | 0.979 | 0.806 | 0.015 | 0.012 | 0.000 | 0.001 | 0.003 | 0.011 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.034 | 0.000 | 0.000 | 0.000 | 0.006 | 0.009 | 0.003 | 0.000 | 0.000 | 1.000 | 0.015 | 1.000 | 0.000 | 0.015 | 0.000 | 0.020 | 0.009 | 0.009 |
| Customer Segment | 0.009 | 0.000 | 0.006 | 0.008 | 0.031 | 0.028 | 0.006 | 0.020 | 0.023 | 0.031 | 0.006 | 0.000 | 0.002 | 0.000 | 0.007 | 0.002 | 0.000 | 0.004 | 0.006 | 0.000 | 0.024 | 0.000 | 0.008 | 0.002 | 0.005 | 0.008 | 0.005 | 0.000 | 0.015 | 0.015 | 1.000 | 0.061 | 0.006 | 0.002 | 0.004 | 0.017 | 0.011 | 0.008 |
| Customer State | 0.027 | 0.011 | 0.000 | 0.008 | 0.050 | 0.974 | 0.010 | 0.799 | 0.644 | 0.050 | 0.026 | 0.008 | 0.005 | 0.000 | 0.025 | 0.000 | 0.001 | 0.000 | 0.000 | 0.011 | 0.072 | 0.008 | 0.008 | 0.000 | 0.023 | 0.027 | 0.024 | 0.018 | 0.008 | 1.000 | 0.061 | 1.000 | 0.009 | 0.030 | 0.000 | 0.026 | 0.022 | 0.027 |
| Department Name | 0.006 | 0.127 | 0.241 | 0.683 | 0.336 | 0.002 | 1.000 | 0.000 | 0.000 | 0.336 | 0.242 | 0.784 | 0.162 | 0.000 | 0.166 | 0.394 | 0.000 | 0.343 | 0.241 | 0.127 | 0.007 | 0.784 | 0.683 | 0.394 | 0.000 | 0.010 | 0.000 | 0.000 | 0.994 | 0.000 | 0.006 | 0.009 | 1.000 | 0.120 | 0.241 | 0.085 | 0.000 | 0.010 |
| Market | 0.008 | 0.021 | 0.036 | 0.158 | 0.179 | 0.013 | 0.119 | 0.008 | 0.013 | 0.179 | 0.753 | 0.129 | 0.024 | 0.000 | 0.714 | 0.059 | 0.005 | 0.042 | 0.036 | 0.021 | 1.000 | 0.129 | 0.158 | 0.059 | 0.011 | 0.007 | 0.006 | 0.005 | 0.176 | 0.015 | 0.002 | 0.030 | 0.120 | 1.000 | 0.027 | 1.000 | 0.011 | 0.007 |
| Order Item Quantity | 0.000 | 0.034 | 0.212 | 0.232 | 0.099 | 0.000 | 0.240 | 0.001 | 0.000 | 0.099 | 0.098 | 0.242 | 0.082 | 0.000 | 0.076 | 0.229 | 0.000 | 0.235 | 0.212 | 0.034 | 0.000 | 0.242 | 0.232 | 0.229 | 0.000 | 0.002 | 0.000 | 0.000 | 0.394 | 0.000 | 0.004 | 0.000 | 0.241 | 0.027 | 1.000 | 0.031 | 0.000 | 0.002 |
| Order Region | 0.022 | 0.014 | 0.026 | 0.118 | 0.134 | 0.018 | 0.089 | 0.015 | 0.018 | 0.134 | 0.551 | 0.105 | 0.018 | 0.000 | 0.532 | 0.060 | 0.000 | 0.042 | 0.026 | 0.014 | 0.922 | 0.105 | 0.118 | 0.060 | 0.019 | 0.023 | 0.018 | 0.017 | 0.084 | 0.020 | 0.017 | 0.026 | 0.085 | 1.000 | 0.031 | 1.000 | 0.017 | 0.023 |
| Order Status | 0.008 | 0.000 | 0.006 | 0.001 | 0.008 | 0.010 | 0.001 | 0.011 | 0.011 | 0.008 | 0.012 | 0.000 | 0.000 | 0.002 | 0.011 | 0.003 | 0.000 | 0.004 | 0.006 | 0.000 | 0.031 | 0.000 | 0.001 | 0.003 | 1.000 | 0.009 | 0.577 | 0.234 | 0.002 | 0.009 | 0.011 | 0.022 | 0.000 | 0.011 | 0.000 | 0.017 | 1.000 | 0.009 |
| Shipping Mode | 0.681 | 0.002 | 0.004 | 0.009 | 0.009 | 0.013 | 0.010 | 0.008 | 0.010 | 0.009 | 0.010 | 0.000 | 0.000 | 0.000 | 0.010 | 0.008 | 0.000 | 0.006 | 0.004 | 0.002 | 0.039 | 0.000 | 0.009 | 0.008 | 0.006 | 1.000 | 0.321 | 0.457 | 0.018 | 0.009 | 0.008 | 0.027 | 0.010 | 0.007 | 0.002 | 0.023 | 0.009 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| Type | Days for shipping (real) | Days for shipment (scheduled) | Benefit per order | Sales per customer | Delivery Status | Late_delivery_risk | Category Id | Category Name | Customer City | Customer Country | Customer Email | Customer Fname | Customer Id | Customer Lname | Customer Password | Customer Segment | Customer State | Customer Street | Customer Zipcode | Department Id | Department Name | Latitude | Longitude | Market | Order City | Order Country | Order Customer Id | order date (DateOrders) | Order Id | Order Item Cardprod Id | Order Item Discount | Order Item Discount Rate | Order Item Id | Order Item Product Price | Order Item Profit Ratio | Order Item Quantity | Sales | Order Item Total | Order Profit Per Order | Order Region | Order State | Order Status | Order Zipcode | Product Card Id | Product Category Id | Product Description | Product Image | Product Name | Product Price | Product Status | shipping date (DateOrders) | Shipping Mode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | DEBIT | 3 | 4 | 91.250000 | 314.640015 | Advance shipping | 0 | 73 | Sporting Goods | Caguas | Puerto Rico | XXXXXXXXX | Cally | 20755 | Holloway | XXXXXXXXX | Consumer | PR | 5365 Noble Nectar Island | 725.0 | 2 | Fitness | 18.251453 | -66.037056 | Pacific Asia | Bekasi | Indonesia | 20755 | 1/31/2018 22:56 | 77202 | 1360 | 13.110000 | 0.04 | 180517 | 327.75 | 0.29 | 1 | 327.75 | 314.640015 | 91.250000 | Southeast Asia | Java Occidental | COMPLETE | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 2/3/2018 22:56 | Standard Class |
| 1 | TRANSFER | 5 | 4 | -249.089996 | 311.359985 | Late delivery | 1 | 73 | Sporting Goods | Caguas | Puerto Rico | XXXXXXXXX | Irene | 19492 | Luna | XXXXXXXXX | Consumer | PR | 2679 Rustic Loop | 725.0 | 2 | Fitness | 18.279451 | -66.037064 | Pacific Asia | Bikaner | India | 19492 | 1/13/2018 12:27 | 75939 | 1360 | 16.389999 | 0.05 | 179254 | 327.75 | -0.80 | 1 | 327.75 | 311.359985 | -249.089996 | South Asia | Rajastán | PENDING | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/18/2018 12:27 | Standard Class |
| 2 | CASH | 4 | 4 | -247.779999 | 309.720001 | Shipping on time | 0 | 73 | Sporting Goods | San Jose | EE. UU. | XXXXXXXXX | Gillian | 19491 | Maldonado | XXXXXXXXX | Consumer | CA | 8510 Round Bear Gate | 95125.0 | 2 | Fitness | 37.292233 | -121.881279 | Pacific Asia | Bikaner | India | 19491 | 1/13/2018 12:06 | 75938 | 1360 | 18.030001 | 0.06 | 179253 | 327.75 | -0.80 | 1 | 327.75 | 309.720001 | -247.779999 | South Asia | Rajastán | CLOSED | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/17/2018 12:06 | Standard Class |
| 3 | DEBIT | 3 | 4 | 22.860001 | 304.809998 | Advance shipping | 0 | 73 | Sporting Goods | Los Angeles | EE. UU. | XXXXXXXXX | Tana | 19490 | Tate | XXXXXXXXX | Home Office | CA | 3200 Amber Bend | 90027.0 | 2 | Fitness | 34.125946 | -118.291016 | Pacific Asia | Townsville | Australia | 19490 | 1/13/2018 11:45 | 75937 | 1360 | 22.940001 | 0.07 | 179252 | 327.75 | 0.08 | 1 | 327.75 | 304.809998 | 22.860001 | Oceania | Queensland | COMPLETE | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/16/2018 11:45 | Standard Class |
| 4 | PAYMENT | 2 | 4 | 134.210007 | 298.250000 | Advance shipping | 0 | 73 | Sporting Goods | Caguas | Puerto Rico | XXXXXXXXX | Orli | 19489 | Hendricks | XXXXXXXXX | Corporate | PR | 8671 Iron Anchor Corners | 725.0 | 2 | Fitness | 18.253769 | -66.037048 | Pacific Asia | Townsville | Australia | 19489 | 1/13/2018 11:24 | 75936 | 1360 | 29.500000 | 0.09 | 179251 | 327.75 | 0.45 | 1 | 327.75 | 298.250000 | 134.210007 | Oceania | Queensland | PENDING_PAYMENT | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/15/2018 11:24 | Standard Class |
| 5 | TRANSFER | 6 | 4 | 18.580000 | 294.980011 | Shipping canceled | 0 | 73 | Sporting Goods | Tonawanda | EE. UU. | XXXXXXXXX | Kimberly | 19488 | Flowers | XXXXXXXXX | Consumer | NY | 2122 Hazy Corner | 14150.0 | 2 | Fitness | 43.013969 | -78.879066 | Pacific Asia | Toowoomba | Australia | 19488 | 1/13/2018 11:03 | 75935 | 1360 | 32.779999 | 0.10 | 179250 | 327.75 | 0.06 | 1 | 327.75 | 294.980011 | 18.580000 | Oceania | Queensland | CANCELED | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/19/2018 11:03 | Standard Class |
| 6 | DEBIT | 2 | 1 | 95.180000 | 288.420013 | Late delivery | 1 | 73 | Sporting Goods | Caguas | Puerto Rico | XXXXXXXXX | Constance | 19487 | Terrell | XXXXXXXXX | Home Office | PR | 1879 Green Pine Bank | 725.0 | 2 | Fitness | 18.242538 | -66.037056 | Pacific Asia | Guangzhou | China | 19487 | 1/13/2018 10:42 | 75934 | 1360 | 39.330002 | 0.12 | 179249 | 327.75 | 0.33 | 1 | 327.75 | 288.420013 | 95.180000 | Eastern Asia | Guangdong | COMPLETE | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/15/2018 10:42 | First Class |
| 7 | TRANSFER | 2 | 1 | 68.430000 | 285.140015 | Late delivery | 1 | 73 | Sporting Goods | Miami | EE. UU. | XXXXXXXXX | Erica | 19486 | Stevens | XXXXXXXXX | Corporate | FL | 7595 Cotton Log Row | 33162.0 | 2 | Fitness | 25.928869 | -80.162872 | Pacific Asia | Guangzhou | China | 19486 | 1/13/2018 10:21 | 75933 | 1360 | 42.610001 | 0.13 | 179248 | 327.75 | 0.24 | 1 | 327.75 | 285.140015 | 68.430000 | Eastern Asia | Guangdong | PROCESSING | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/15/2018 10:21 | First Class |
| 8 | CASH | 3 | 2 | 133.720001 | 278.589996 | Late delivery | 1 | 73 | Sporting Goods | Caguas | Puerto Rico | XXXXXXXXX | Nichole | 19485 | Olsen | XXXXXXXXX | Corporate | PR | 2051 Dusty Route | 725.0 | 2 | Fitness | 18.233223 | -66.037056 | Pacific Asia | Guangzhou | China | 19485 | 1/13/2018 10:00 | 75932 | 1360 | 49.160000 | 0.15 | 179247 | 327.75 | 0.48 | 1 | 327.75 | 278.589996 | 133.720001 | Eastern Asia | Guangdong | CLOSED | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/16/2018 10:00 | Second Class |
| 9 | CASH | 2 | 1 | 132.149994 | 275.309998 | Late delivery | 1 | 73 | Sporting Goods | San Ramon | EE. UU. | XXXXXXXXX | Oprah | 19484 | Delacruz | XXXXXXXXX | Corporate | CA | 9139 Blue Blossom Court | 94583.0 | 2 | Fitness | 37.773991 | -121.966629 | Pacific Asia | Guangzhou | China | 19484 | 1/13/2018 9:39 | 75931 | 1360 | 52.439999 | 0.16 | 179246 | 327.75 | 0.48 | 1 | 327.75 | 275.309998 | 132.149994 | Eastern Asia | Guangdong | CLOSED | NaN | 1360 | 73 | NaN | http://images.acmesports.sports/Smart+watch | Smart watch | 327.75 | 0 | 1/15/2018 9:39 | First Class |
| Type | Days for shipping (real) | Days for shipment (scheduled) | Benefit per order | Sales per customer | Delivery Status | Late_delivery_risk | Category Id | Category Name | Customer City | Customer Country | Customer Email | Customer Fname | Customer Id | Customer Lname | Customer Password | Customer Segment | Customer State | Customer Street | Customer Zipcode | Department Id | Department Name | Latitude | Longitude | Market | Order City | Order Country | Order Customer Id | order date (DateOrders) | Order Id | Order Item Cardprod Id | Order Item Discount | Order Item Discount Rate | Order Item Id | Order Item Product Price | Order Item Profit Ratio | Order Item Quantity | Sales | Order Item Total | Order Profit Per Order | Order Region | Order State | Order Status | Order Zipcode | Product Card Id | Product Category Id | Product Description | Product Image | Product Name | Product Price | Product Status | shipping date (DateOrders) | Shipping Mode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180509 | PAYMENT | 3 | 4 | 0.000000 | 335.980011 | Advance shipping | 0 | 45 | Fishing | Caguas | Puerto Rico | XXXXXXXXX | Melissa | 7 | Wilcox | XXXXXXXXX | Corporate | PR | 9453 High Concession | 725.0 | 7 | Fan Shop | 18.359095 | -66.079956 | Pacific Asia | Guangshui | China | 7 | 1/16/2016 6:49 | 26052 | 1004 | 64.0 | 0.16 | 65202 | 399.980011 | 0.00 | 1 | 399.980011 | 335.980011 | 0.000000 | Eastern Asia | Hubei | PENDING_PAYMENT | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/19/2016 6:49 | Standard Class |
| 180510 | PAYMENT | 3 | 4 | 165.990005 | 331.980011 | Advance shipping | 0 | 45 | Fishing | Caguas | Puerto Rico | XXXXXXXXX | Melissa | 7 | Wilcox | XXXXXXXXX | Corporate | PR | 9453 High Concession | 725.0 | 7 | Fan Shop | 18.359095 | -66.079956 | Pacific Asia | Guangshui | China | 7 | 1/16/2016 6:49 | 26052 | 1004 | 68.0 | 0.17 | 65201 | 399.980011 | 0.50 | 1 | 399.980011 | 331.980011 | 165.990005 | Eastern Asia | Hubei | PENDING_PAYMENT | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/19/2016 6:49 | Standard Class |
| 180511 | DEBIT | 2 | 2 | 157.429993 | 327.980011 | Shipping on time | 0 | 45 | Fishing | Chula Vista | EE. UU. | XXXXXXXXX | Olivia | 9314 | Smith | XXXXXXXXX | Consumer | CA | 3760 Stony Promenade | 91911.0 | 7 | Fan Shop | 32.611141 | -117.073662 | Pacific Asia | Chengdu | China | 9314 | 1/16/2016 6:28 | 26051 | 1004 | 72.0 | 0.18 | 65195 | 399.980011 | 0.48 | 1 | 399.980011 | 327.980011 | 157.429993 | Eastern Asia | Sichuan | ON_HOLD | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/18/2016 6:28 | Second Class |
| 180512 | DEBIT | 6 | 4 | 86.400002 | 319.980011 | Late delivery | 1 | 45 | Fishing | Caguas | Puerto Rico | XXXXXXXXX | Mary | 7396 | Madden | XXXXXXXXX | Home Office | PR | 9918 Lazy Cape | 725.0 | 7 | Fan Shop | 18.245256 | -66.370621 | Pacific Asia | Chengdu | China | 7396 | 1/16/2016 6:07 | 26050 | 1004 | 80.0 | 0.20 | 65194 | 399.980011 | 0.27 | 1 | 399.980011 | 319.980011 | 86.400002 | Eastern Asia | Sichuan | COMPLETE | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/22/2016 6:07 | Standard Class |
| 180513 | PAYMENT | 3 | 4 | 119.989998 | 299.989990 | Advance shipping | 0 | 45 | Fishing | Lancaster | EE. UU. | XXXXXXXXX | Mary | 3080 | Smith | XXXXXXXXX | Home Office | OH | 8600 Red Goose Abbey | 43130.0 | 7 | Fan Shop | 39.715977 | -82.599297 | Pacific Asia | Shanghái | China | 3080 | 1/16/2016 5:04 | 26047 | 1004 | 100.0 | 0.25 | 65185 | 399.980011 | 0.40 | 1 | 399.980011 | 299.989990 | 119.989998 | Eastern Asia | Shanghái | PENDING_PAYMENT | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/19/2016 5:04 | Standard Class |
| 180514 | CASH | 4 | 4 | 40.000000 | 399.980011 | Shipping on time | 0 | 45 | Fishing | Brooklyn | EE. UU. | XXXXXXXXX | Maria | 1005 | Peterson | XXXXXXXXX | Home Office | NY | 1322 Broad Glade | 11207.0 | 7 | Fan Shop | 40.640930 | -73.942711 | Pacific Asia | Shanghái | China | 1005 | 1/16/2016 3:40 | 26043 | 1004 | 0.0 | 0.00 | 65177 | 399.980011 | 0.10 | 1 | 399.980011 | 399.980011 | 40.000000 | Eastern Asia | Shanghái | CLOSED | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/20/2016 3:40 | Standard Class |
| 180515 | DEBIT | 3 | 2 | -613.770019 | 395.980011 | Late delivery | 1 | 45 | Fishing | Bakersfield | EE. UU. | XXXXXXXXX | Ronald | 9141 | Clark | XXXXXXXXX | Corporate | CA | 7330 Broad Apple Moor | 93304.0 | 7 | Fan Shop | 35.362545 | -119.018700 | Pacific Asia | Hirakata | Japón | 9141 | 1/16/2016 1:34 | 26037 | 1004 | 4.0 | 0.01 | 65161 | 399.980011 | -1.55 | 1 | 399.980011 | 395.980011 | -613.770019 | Eastern Asia | Osaka | COMPLETE | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/19/2016 1:34 | Second Class |
| 180516 | TRANSFER | 5 | 4 | 141.110001 | 391.980011 | Late delivery | 1 | 45 | Fishing | Bristol | EE. UU. | XXXXXXXXX | John | 291 | Smith | XXXXXXXXX | Corporate | CT | 97 Burning Landing | 6010.0 | 7 | Fan Shop | 41.629959 | -72.967155 | Pacific Asia | Adelaide | Australia | 291 | 1/15/2016 21:00 | 26024 | 1004 | 8.0 | 0.02 | 65129 | 399.980011 | 0.36 | 1 | 399.980011 | 391.980011 | 141.110001 | Oceania | Australia del Sur | PENDING | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/20/2016 21:00 | Standard Class |
| 180517 | PAYMENT | 3 | 4 | 186.229996 | 387.980011 | Advance shipping | 0 | 45 | Fishing | Caguas | Puerto Rico | XXXXXXXXX | Mary | 2813 | Smith | XXXXXXXXX | Consumer | PR | 2585 Silent Autumn Landing | 725.0 | 7 | Fan Shop | 18.213350 | -66.370575 | Pacific Asia | Adelaide | Australia | 2813 | 1/15/2016 20:18 | 26022 | 1004 | 12.0 | 0.03 | 65126 | 399.980011 | 0.48 | 1 | 399.980011 | 387.980011 | 186.229996 | Oceania | Australia del Sur | PENDING_PAYMENT | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/18/2016 20:18 | Standard Class |
| 180518 | PAYMENT | 4 | 4 | 168.949997 | 383.980011 | Shipping on time | 0 | 45 | Fishing | Caguas | Puerto Rico | XXXXXXXXX | Andrea | 7547 | Ortega | XXXXXXXXX | Consumer | PR | 697 Little Meadow | 725.0 | 7 | Fan Shop | 18.290380 | -66.370613 | Pacific Asia | Nagercoil | India | 7547 | 1/15/2016 18:54 | 26018 | 1004 | 16.0 | 0.04 | 65113 | 399.980011 | 0.44 | 1 | 399.980011 | 383.980011 | 168.949997 | South Asia | Tamil Nadu | PENDING_PAYMENT | NaN | 1004 | 45 | NaN | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 399.980011 | 0 | 1/19/2016 18:54 | Standard Class |